SCCM query
Question
solved 0
Configuration Manager 2 years 2020-07-12T10:09:23+05:30 2020-07-12T10:09:23+05:30 4 Answers 246 views Beginner 0Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Answers ( 4 )
Hi Karthik ,
i added document in question .need such information.
Thank you Anoop and karthik .
let me check result for this .
Hi Karthik can we make for particular collection and sup .
–All machines SUP Scan detailed report
——————————————————–
select
distinct Vrs.name0 as ‘ComputerName’,
os.caption0 as ‘OSName’,
Vrs.user_name0 as ‘UserName’,
convert(nvarchar(26),ws.lasthwscan,100) as ‘LastHWScan’,
convert(nvarchar(26),uss.LastScanTime,100) as ‘LastSUPScan’,
uss.lasterrorcode as ‘LastSUPScanStatus’,
uss.lastscanpackagelocation as ‘SUPLocationPath’
from v_r_system as Vrs
Left join v_gs_operating_system as os on os.resourceid=Vrs.resourceid
Left join v_GS_WORKSTATION_STATUS as ws on ws.resourceid=Vrs.resourceid
Left join v_updatescanstatus as uss on uss.ResourceId=Vrs.ResourceID
order by uss.lasterrorcode
Can you try the following queries