Skip to Content
avatar image
Former Member

SQL master database in HANA

Hello

I need to run the following query on SAP b1 HANA :

SELECT @@Servername as ServerName, B.name as Database_Name,

ISNULL(STR(ABS(DATEDIFF(day, GetDate(),

MAX(Backup_finish_date)))), 'NEVER') as DaysSinceLastBackup,

ISNULL(Convert(char(10), MAX(backup_finish_date), 101), 'NEVER') as LastBackupDate,

GetDate() as CollectionTimeStamp

FROM master.dbo.sysdatabases B

LEFT OUTER JOIN msdb.dbo.backupset A ON A.database_name collate database_default = B.name collate database_default

AND A.type = 'D'

GROUP BY B.Name ORDER BY B.name

2nd Query :

SELECT * FROM sys.remote_logins

Please can someone assist in the schema name for master and msdb in sap b1 hana.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers