SELECT CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server, msdb.dbo.backupset.database_name, msdb.dbo.backupset.backup_start_date, msdb.dbo.backupset.backup_finish_date, msdb.dbo.backupset.expiration_date, CASE msdb..backupset.type WHEN 'D' THEN 'Database' WHEN 'L' THEN 'Log' END AS backup_type, msdb.dbo.backupset.backup_size, msdb.dbo.backupmediafamily.logical_device_name, msdb.dbo.backupmediafamily.physical_device_name, msdb.dbo.backupset.name AS backupset_name, msdb.dbo.backupset.description FROM msdb.dbo.backupmediafamily INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id WHERE (CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 10) -- 10 días ORDER BY msdb.dbo.backupset.database_name, msdb.dbo.backupset.backup_finish_date ############################################ msdb.dbo.backupset.database_name, msdb.dbo.backupset.backup_s
select @@servername , (select COUNT(1) from sys.dm_os_schedulers where status in ('VISIBLE ONLINE','VISIBLE OFFLINE')) as [Cores totales] , (select COUNT(1) from sys.dm_os_schedulers where status = 'VISIBLE ONLINE') as [Cores utilizados]