Hello
i have to query that returns SCCM error codes based on collection name and softwarename.
This query is running well but in order to get the error codes, i use the view 'v_CIErrorDetails' whitch returns a lot of errors. I suppose these errors are history that SCCM keeps.
Is there a way to filter down that table and get only the more recent one ?
or another table that only shows current status and not the whole history ?
i've been looking at all the views in there but didn't find the one i need : https://docs.microsoft.com/en-us/me...mpliance-settings-views-configuration-manager
this would be a life saver
thank you
i have to query that returns SCCM error codes based on collection name and softwarename.
This query is running well but in order to get the error codes, i use the view 'v_CIErrorDetails' whitch returns a lot of errors. I suppose these errors are history that SCCM keeps.
Is there a way to filter down that table and get only the more recent one ?
or another table that only shows current status and not the whole history ?
i've been looking at all the views in there but didn't find the one i need : https://docs.microsoft.com/en-us/me...mpliance-settings-views-configuration-manager
this would be a life saver
thank you
