Wednesday, 8 April 2015

SQL Database to Query MetaData of Software update in SCCM 2012

SQL Database to Query MetaData of Software update in SCCM 2012

Software Updates MetaData Query to get more information on sync process

select * from ci_types



 

image


 


Each citype_id will have Updates List i.e., CI Unique ID’s, see below when Queries for further

 


image


you can click the update link in the SDMPackageDigest column to get more details like .exe file name or .msi file that will download from SCCM DP.

No comments:

Post a Comment