sql

This SCCM report is really a complicated one, I used lots of views to do the information I need, such as : AD Site, Machine … Read more

select all SMS_R_System.Name0,SMS_R_System.Last_Logon_Timestamp0,SMS_R_System.Resource_Domain_OR_Workgr0,SMS_R_System.Client0,SMS_R_System.Operating_System_Name_and0 from vSMS_R_System AS SMS_R_System WHERE (Client0 IS NULL) AND (Operating_System_Name_and0 NOT LIKE N’%OS X%’) AND (Operating_System_Name_and0 LIKE N’%Microsoft Windows NT Workstation%’) ORDER … Read more

I am working on SCCM reports a lot lately, here is the SQL statement for Last Hardware Scan Over 37 Days SELECT dbo.v_R_System.AD_Site_Name0, dbo.v_R_System.Name0, dbo.v_R_System.User_Name0, … Read more