If you have added the lastLogonTimestamp field into the AD System Discovery, you can use this SQL Statement:
Category: Microsoft
So that one is great and all, but here’s one that presents a little more detail
select distinct ( name0 ) , creation_date0 , datediff ( day , creation_date0 , { fn Now ()}) as Age , CLIENT0 , ad_site_name0 , active0 from v_r_system where (
select distinct ServerName , vss . percentfree , vss . status , dp . sitecode , dp . bitsenabled , vss . DownSince , vss . TimeReported from vSummarizer_SiteSystem as
This handly little SQL Script will get you a count of all Machines in SCCM by Operating System: Â select count ( operating_system_name_and0 ) as Total , operating_system_name_and0 from v_r_system
declare @collection varchar set @collection = ‘%’ select CS . Name0 , CS . Domain0 , CS . UserName0 , CS . Manufacturer0 , CS . Model0 , CS .
Select Deploymentname , Available , Deadline , cast ( cast ((( cast ( [Compliant] as float ) / ( ISNULL ( [Compliant] , 0 ) + ISNULL ( [Enforcement state
Showing All computers in SCCM that have software installed, with the last boot time listed DECLARE @lookup as varchar (50) set @lookup = ‘%’ SELECT Â Â Â Â TOP (100) PERCENT dbo.v_R_System.Name0,
So, Let’s say you need to see all machines that contain a specific software package, you can use sccm’s gui, or you can do it in SQL, where you can