SCCM Report – Software Metering Report for Last Usage Over 30 Days Ago

Here is my SQL Statement for SCCM Report – Software Metering Report for Last Usage Over 30 Days Ago   SELECT DISTINCT TOP (100) PERCENT RV.AD_Site_Name0, v_R_User_1.description0, RV.Netbios_Name0, RV.User_Name0, MAX(MUS.LastUsage) AS Expr1, OS.Caption0, RV.Creation_Date0, v_R_User_1.department0, v_R_User_1.Mail0, v_R_User_1.manager0, v_R_User_1.title0, MF.MeteredFileName, MF.MeteredFileVersion FROM dbo.v_R_System_Valid AS RV INNER JOIN dbo.v_MonthlyUsageSummary AS MUS ON RV.ResourceID = MUS.ResourceID INNER JOIN […]

SCCM Reports – No SCCM agent workstation client

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 by 2

SCCM Reports – Last Hardware Scan Over 37 Days

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, dbo.v_R_System.Operating_System_Name_and0, dbo.v_R_User.department0, dbo.v_R_User.Mail0, dbo.v_R_User.title0, dbo.v_GS_WORKSTATION_STATUS.LastHWScan FROM dbo.v_GS_WORKSTATION_STATUS INNER JOIN dbo.v_R_System ON dbo.v_GS_WORKSTATION_STATUS.ResourceID = dbo.v_R_System.ResourceID INNER JOIN dbo.v_R_User ON dbo.v_R_System.User_Name0 = dbo.v_R_User.User_Name0 WHERE (DATEDIFF(day, dbo.v_GS_WORKSTATION_STATUS.LastHWScan, GETDATE()) >= 37) order by 8