SQL Query

Hi All,

Hi All,

I’m trying to create a report that will give me the “Status”, and “Error Description”, I get from the Device Summary section in the “Assets Message” window under the “Details” tab for each system. I’m looking to get this from systems that are under the “In Progess” and “Error” tabs of the Deployment Status. For example, I’d like to identify the System, Status(Failed to install updates), and Error Description(No current or future service window exists to install software updates) in a report. I’ve been unsuccessful in finding where this information is in the database/view to write my query, so any help would be greatly appreciated.