2/13/2023 0 Comments Sccm report builder downloadThere are lot of patch compliance reports on my blog with different requirements ,so have a look at them ,download the RDL file ,edit the RDL file using your favorite Tool(Report builder or BI or Visual studio etc) ,Įdit the RDL file,copy the code into SQL server management studio ,do adjustments what is needed for you and get back the query to SSRS Report. If your management asked for any patch compliance report, get them overall compliance status from specific collection for specific update group (this will get overall compliance from specific software update group only) or compliance status for each machine from specific collection (this will generate report with all updates in your Configmgr). ![]() So ,how do you perform basic software update compliance audit ? There are variety of reports available by default in Configmgr with category Software Updates - A Compliance. ![]() Garth has blogged similar kind of requirement How to perform basic Software Audit ,read it here ![]() You should not encourage for such unrealistic requests,if they are going to ask you,tell them ,what they are going to get. Management wants to know if the PC is compliant or not. So if you are going to generate report for management to show ,what is the compliance status (this is not really compliance status required for Management) with this requirement,Are they going to read it ? How does it matter to them,if particular computer is missing XX number of patches. So when you generate report with this requirement,you know how many rows do you get ? X (number of clients)* Y (number of patches).Īssume X=200 Clients and Y =100 Patches (till date) ,the report consists of 200* 100=20,000 rows. A collection may contain X number of clients and each client may produce Y Number of patches for sure from your Configmgr environment with compliance status. ![]() There are couple of posts on TechNet blog and other forums asking for ‘ Is there any report that list all updates with compliance status for specific collection’ ? Read it once again ,A software update compliance report that list all updates whether Targeted, Installed, Missing for specific Collection.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |