PENDING installed, missing patches Query in sccm

[venkateshcme_81]

Dear Team,
1) I have installed SCCM Trail Version
2) i have installed WSUS & Configured SUP
3) products & calssifications also set
4) boundries are in place
5)client settings- software updates enabled

i have win-10 ,3 clients, recently installed sccm agent and no errors in Soft updates logs scan success no issues.
i want to know installed and not installed patches for a collection through sccm sql query (NO SUG created n No deployments so far brand new enviornment)
any support is highly appreciated.


thanks

 

[Garth]

Dear Team,
1) I have installed SCCM Trail Version
2) i have installed WSUS & Configured SUP
3) products & calssifications also set
4) boundries are in place
5)client settings- software updates enabled

i have win-10 ,3 clients, recently installed sccm agent and no errors in Soft updates logs scan success no issues.
i want to know installed and not installed patches for a collection through sccm sql query (NO SUG created n No deployments so far brand new enviornment)
any support is highly appreciated.


thanks

Look at the default reports, they are are not exactly to your liking you can edit them.

 

[venkateshcme_81]

Hi garth thanks for your reply,

with this new fresh environment and fresh clients brought to SCCM
is it possible to get the INSTALLED, MISSING PATCHES for these systems or not? So that I can confirm the same to my team n close this.
If yes plz help me with the SQL Query/ SCCM inbuilt report

That would be really a great help

Venky

 

[Garth]

Once you install the SUP all SU details will be returned to ConfigMgr. And therefore all reports will work after that.

I will never create a report for you. I will however help you fix one. e.g. help you learn.

 

[venkateshcme_81]

SUP installed.
SU scan is success in all 3 test machines.
Still all updates are showing 0 in required column. in sccm console
need patch report unable to get the patch report INSTALLED, MISSING PATCHES for these systems -as we have not created any SUG n deployed

will we get the patch report or not at this stage if yes suggest me any inbuilt reports

 

[venkateshcme_81]

can anybody throw some light on this and help me on this plz
stuck very badly