This is great! Thanks Sherry! Sent from my iPhone
On Jul 17, 2017, at 12:00 PM, Sherry Kissinger <sherrylkissin...@gmail.com<mailto:sherrylkissin...@gmail.com>> wrote: We have a few times in the past via the console modified "severity" using the Custom Severity field, so for us the sql has to take that into account. We also don't care about anything itanium. You can do other limits, like in the where clause say you only want isexpired=0 and isSuperseded=0, or that DatePosted is after 7/10/2017. ;with cte as ( select CI_ID, BulletinID, ArticleID, Title, DatePosted, DateRevised, isExpired, isSuperseded, CI_UniqueID, case when (ui.severity=0 and ui.CustomSeverity=0) or ui.severity is null then '0 None' when ui.CustomSeverity=6 then '6 Moderate' when ui.CustomSeverity=8 then '8 Important' when ui.CustomSeverity=10 then '10 Critical' when ui.CustomSeverity=2 then '2 Low' when ui.Severity=2 and ui.CustomSeverity=0 then '2 Low' when ui.Severity=6 and ui.CustomSeverity=0 then '6 Moderate' when ui.Severity=8 and ui.CustomSeverity=0 then '8 Important' when ui.Severity=10 and ui.CustomSeverity=0 then '10 Critical' end as 'Severity' from v_UpdateInfo ui Where ui.title not like '%Itanium%' ) select severity, count(*) [Count] from cte group by Severity order by Severity On Mon, Jul 17, 2017 at 9:39 AM, Eswar <es...@eskonr.com<mailto:es...@eskonr.com>> wrote: Hi Brian, Yes you can get that information using sql. I can get you that information tommrrow. -- Regards Eswar Koneti www.eskonr.com<http://www.eskonr.com> Sent from mobile device, please excuse any typo's as a result Friday, 14 July 2017, 09:20PM +08:00 from Brian McDonald mcdonald...@hotmail.com<mailto:mcdonald...@hotmail.com>: Hello, Is there any way to report on how many software updates are critical/high/med/low in SCCM? Thanks, Brian Sent from my iPhone -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blog: http://mnscug.org/blogs/sherry-kissinger
