sccm reporting

Here is the SQL  statement for my SCCM Report on disk free space under 20%, it will display the user machine AD Site, PC Name, Last Logon User, Total Disk Space, Free Space, Free Space Percent( All in GB), Drive Name, Model Name ( Lenovo models will be on Model #1, the rest will be […]

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 […]