Bad news I used the query below and nothing changed:
select count(*) [Total Clients], li.title,coll.name, SUM (CASE WHEN ucs.status=3 or ucs.status=1 then 1 ELSE 0 END ) as 'Installed / Not Applicable', sum( case When ucs.status=2 Then 1 ELSE 0 END ) as 'Required', sum( case When ucs.status=0 Then 1 ELSE 0 END ) as 'Unknown', round((CAST(SUM (CASE WHEN ucs.status=3 or ucs.status=1 THEN 1 ELSE 0 END) as float)/count(*) )*100,2) as 'Success %', round((CAST(count(case when ucs.status not in('3','1') THEN '*' end) as float)/count(*))*100,2) as 'Not Success%', LI.DateCreated as 'Datecreated'From dbo.v_Update_ComplianceStatusAll UCS inner join v_r_system sys on ucs.resourceid=sys.resourceid inner join v_FullCollectionMembership fcm on ucs.resourceid=fcm.resourceid inner join v_collection coll on coll.collectionid=fcm.collectionid inner join v_AuthListInfo LI on ucs.ci_id=li.ci_id where coll.CollectionID = @collname and LI.CI_UniqueID in (@AuthListID) group by li.title,coll.name,LI.DateCreatedorder by LI.DateCreated
Then I modified the CategoryGroups to the new DateCreate field. Good news is that kind of works.
I can now sort the updates by when they were deployed. Issue is it now shows the data aka date it was deployed, and NOT the actual Software Update Group name. Do you know if there is anyway I can still sort by this date field but still show the update group name\title?
As you can see it worked, kinda.
That conf looks pretty cool. I didn't even know it existed and I've lived in MN most of my life. I've been to EMC world in Vegas about 4 times but that's about for me and conferences. If you want to have a local show you the town or take you to dinner while your up here let me know. I'd be happy to show you around or take you to dinner whatever. I hope the weather is nice while your up here. Weather is pretty important up here. Can be really nice or make ya wanna stay indoors.
Thanks again for all your help!!! Its pretty rare plp or strangers help out and get nothing in return. So its noticed and appreciated.
Good news and bad news.