GarthMJ

Is this CM07, CM12 or SMS2k3? Are you talking about SSRS or ASP report?

So what was the query?

I’m not sure that I’m following you. All you need to do is create the SQL query and then you can create the report either SSRS or ASP.

Try re-install the Reporting point.

The only way to solve this is to delete the status message from the database, there is no supported way to do this however all status message should be move after ~90 days.

Yes you can gather this information with CM07. You will need to edit the sms_def.mof to collect AdminPasswordStatus from Win32_ComputerSystem http://msdn.microsof...2(v=vs.85).aspx