declare @collection varchar set @collection = ‘%’ select CS . Name0 , CS . Domain0 , CS . UserName0 , CS . Manufacturer0 , CS . Model0 , CS .
Category: SCCM
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