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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.