#sql
5 posts
-
Jan 24, 2017
SCCM Report for Disk Free Space Under 20%
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...
-
Jan 20, 2017
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,...
-
Dec 9, 2016
SCCM Reports - Software Update Status
This SCCM report is really a complicated one, I used lots of views to do the information I need, such as : AD Site, Machine Name, Last Logon User, Last Update Scan, Last Logon Timestamp, Update...
-
Dec 9, 2016
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\...
-
Dec 9, 2016
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,...