How to Create a SCCM Application Catalog Usage Report?

It is an interesting experience to write SQL query about SCCM Application Catalog Usage Report, as we need to use a function query:¬†(fn_ListLatestApplicationCIs(1033) from this function, we can get the data of¬†Manufacturer, DisplayName, SoftwareVersion, CI_UniqueID, ModelID, SDMPackageVersion, DateCreated, LastModifiedBy from our SCCM.   Anyway, here is my SQL Query: select app.RequestID as ‘ReqID’, (select top […]