tag:blogger.com,1999:blog-8996856623096968372.post6710114068156349536..comments2023-08-26T12:19:30.733+02:00Comments on pleasepressanykey: SCCM PatchMgmt - Custom Reportsmerowingerhttp://www.blogger.com/profile/05679656055137095951noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-8996856623096968372.post-69950646742331204122018-08-03T10:40:58.920+02:002018-08-03T10:40:58.920+02:00Very usefull and still working with SCCM 1802 !Very usefull and still working with SCCM 1802 !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-81187811862998424572015-12-08T10:47:26.290+01:002015-12-08T10:47:26.290+01:00Hey,
VERY USEFUL! THANKS!Hey,<br /><br />VERY USEFUL! THANKS!MusicManiachttps://www.blogger.com/profile/04822411732293878231noreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-40322755489392781442014-01-10T22:33:59.650+01:002014-01-10T22:33:59.650+01:00These were a huge help! Thanks so much for postin...These were a huge help! Thanks so much for posting them. They have proven useful within some of the Orchestrator runbooks for patch automation.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-52773756575316130932013-09-05T19:13:32.727+02:002013-09-05T19:13:32.727+02:00Still having trouble getting the prompts to work p...Still having trouble getting the prompts to work properly in the "Assinged Updates in an UpdateList and current State for a specific Computer" report.. Can you explain how to properly create these prompts?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-29548570383024515562013-02-13T05:43:58.355+01:002013-02-13T05:43:58.355+01:00Hi,
I am looking for SCCM2012 query for patch stat...Hi,<br />I am looking for SCCM2012 query for patch status from specific deployment and specific collection. I need the following details in my patch report with against each machine name<br />Total patch count in deployment<br />Total patch count installed<br />Total patch count missing<br />Total patch count not required<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-38977715331918559702013-02-13T05:42:50.695+01:002013-02-13T05:42:50.695+01:00Hi,
I am looking for SCCM2012 query for patch stat...Hi,<br />I am looking for SCCM2012 query for patch status from specific deployment and specific collection. I need the following details in my patch report<br />Total patch count in deployment<br />Total patch count installed<br />Total patch count missing<br />Total patch count not required<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-34122043876144226052012-08-22T14:55:51.991+02:002012-08-22T14:55:51.991+02:00Hi HeyAdmin,
thank you for you interest.
Please po...Hi HeyAdmin,<br />thank you for you interest.<br />Please post your question in a tech forum like experts-exchange.com or myitforum.com as i don't have the time to answer it at the moment.<br />Thank youmerowingerhttps://www.blogger.com/profile/05679656055137095951noreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-7594041024450155612012-08-21T18:47:22.994+02:002012-08-21T18:47:22.994+02:00In my example above, the third column didnt' a...In my example above, the third column didnt' appear as I had typed in in my post. It would be a description of the required bulletin ID.HeyAdminnoreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-78778092787749176462012-08-21T18:46:00.897+02:002012-08-21T18:46:00.897+02:00I'm looking for a single report that prompts f...I'm looking for a single report that prompts for an update list and collection, and lists all the required patches for that collection. The first column is the machine name, second column is the bulletin id, third column is a description of the bulletin. If a machine is missing more than one patch, there would be multiple rows for that machine. Sort of like this:<br /><br />Machine1 HeyAdminnoreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-89118786128092392712012-06-24T12:40:43.432+02:002012-06-24T12:40:43.432+02:00yes you have to define a prompt for every variable...yes you have to define a prompt for every variable (@xxx).<br /><br />For the Computername you can create the prompt with this query:<br />select * from v_R_System<br /><br />For the Updatelist you can create the prompt with this query:<br />select * from v_AuthListInfomerowingerhttps://www.blogger.com/profile/05679656055137095951noreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-85882511979549499132012-06-22T18:39:05.936+02:002012-06-22T18:39:05.936+02:00Do I need to create prompts for these reports? So...Do I need to create prompts for these reports? Sorry...new to SCCM reports.HeyAdminhttps://www.blogger.com/profile/09833960271283582795noreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-47243129931244403112012-04-17T19:38:56.566+02:002012-04-17T19:38:56.566+02:00Are the prompts are correct?
Are you sure the Cli...Are the prompts are correct? <br />Are you sure the Client has reported the Update Scan Result to WSUS and SCCM?merowingerhttps://www.blogger.com/profile/05679656055137095951noreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-49905397822965151292012-04-16T19:57:27.395+02:002012-04-16T19:57:27.395+02:00Hello, I'm trying to use your report "Ass...Hello, I'm trying to use your report "Assinged Updates in an UpdateList and current State for a specific Computer". I have added in the two prompts for COMPUTERNAME and UPDATELIST by copying the scripts from existing reports.<br /><br />When I run the report I get "No matching records found". Do you have any idea why this isn't working?Anonymoushttps://www.blogger.com/profile/16472525673658851659noreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-43237285179841862532012-04-16T19:21:18.957+02:002012-04-16T19:21:18.957+02:00Hello! I am trying to use your report "Assing...Hello! I am trying to use your report "Assinged Updates in an UpdateList and current State for a specific Computer". I added in the prompt for COMPUTERNAME and UPDATELIST by copying the prompts for existing reports. When I run the report I get "No matching records found.".<br /><br />Would you have any ideas why this isn't working?<br />Thanks,<br />JoelAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8996856623096968372.post-82278953876021924242012-04-16T18:29:04.477+02:002012-04-16T18:29:04.477+02:00Hello! I have attempted to use your report "A...Hello! I have attempted to use your report "Assinged Updates and current State for a specific Computer". I created the prompts for COMPUTERNAME and UPDATELIST by copying the scripts from other existing reports. <br /><br />However when run your report I get "No matching records could be found."<br /><br />Would you have any insight into why this would be the case?<br /><br />Anonymousnoreply@blogger.com