sccmug

select     OS.Caption0,     CS.SystemType0,     Count(*)from     dbo.v_GS_COMPUTER_SYSTEM CS Left Outer Join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceIdGroup by     OS.Caption0,     CS.SystemType0Order by     OS.Caption0,     CS.SystemType0

select     CS.Name0,     PSE.Status0,     count(PSE.Status0)from     dbo.v_GS_Computer_System cs left outer join dbo.v_GS_PATCHSTATEEX PSE on CS.ResourceID = PSE.ResourceID    left outer join dbo.v_GS_SYSTEM S on CS.ResourceID = S.ResourceID Where     S.SystemRole0 = ‘Server’Group by     CS.Name0,     PSE.Status0

The output of this query can be used to create a batch file to execute service control to fix BITS service. Open  SQL  Server Management Studio and paste this query. Edit it as you need. Execute the query Save the result panel as fixbits.bat Finally open a DOS Prompt Make sure that sc.exe is located […]

Select     CS.Name0,    ARP.DisplayName0From    dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_Add_Remove_Programs ARP on CS.REsourceID = ARP.ResourceIDWhere    ARP.DisplayName0 in (‘Microsoft SQL Server 2005 Tools’, ‘Virtual Machine Additions’,’Windows Resource Kit Tools’)

Select     cs.Name0,     DateDiff(hour,os.LastBootUpTime0,ws.LastHWScan) as ‘Uptime (in Hours)’,    os.LastBootUpTime0 as ‘Last Reboot Date/Time’,     ws.LastHWScan as ‘Last Hardware Inventory’From     dbo.v_GS_WORKSTATION_STATUS ws     Left Outer Join dbo.v_GS_Operating_System os on ws.ResourceID = os.ResourceID       left outer join dbo.v_GS_COMPUTER_SYSTEM cs on cs.ResourceID = os.ResourceID     left outer join dbo.v_GS_SYSTEM sys on sys.ResourceID = os.ResourceID Where    Sys.SystemRole0=’Server’Order by […]