https://community.hpe.com/t5/server-management-systems/sql-query-quot-overall-software-status-quot-table-hp-sim/m-p/4611715#M40561 <BR />I can find the "Overal device status' under R_Inventory.Device status,,,<BR /><BR />But what i need is the query for "overall software status" from SIM<BR /><BR />or from a guest (localhost:2381) it would be "HP Version control agent status. Imagine the sql table would hold a 1,2,3,4 etc for status Fri, 02 Apr 2010 20:00:20 GMT PaulDoerr 2010-04-02T20:00:20Z https://community.hpe.com/t5/server-management-systems/sql-query-quot-overall-software-status-quot-table-hp-sim/m-p/4611715#M40561 <BR />I can find the "Overal device status' under R_Inventory.Device status,,,<BR /><BR />But what i need is the query for "overall software status" from SIM<BR /><BR />or from a guest (localhost:2381) it would be "HP Version control agent status. Imagine the sql table would hold a 1,2,3,4 etc for status Fri, 02 Apr 2010 20:00:20 GMT https://community.hpe.com/t5/server-management-systems/sql-query-quot-overall-software-status-quot-table-hp-sim/m-p/4611715#M40561 PaulDoerr 2010-04-02T20:00:20Z https://community.hpe.com/t5/server-management-systems/sql-query-quot-overall-software-status-quot-table-hp-sim/m-p/4611716#M40562 No help. I will need to escalate this. Wed, 07 Apr 2010 21:05:10 GMT https://community.hpe.com/t5/server-management-systems/sql-query-quot-overall-software-status-quot-table-hp-sim/m-p/4611716#M40562 PaulDoerr 2010-04-07T21:05:10Z https://community.hpe.com/t5/server-management-systems/sql-query-quot-overall-software-status-quot-table-hp-sim/m-p/4611717#M40563 I escalated this, and HP has disappointed. Thu, 10 Jun 2010 16:10:01 GMT https://community.hpe.com/t5/server-management-systems/sql-query-quot-overall-software-status-quot-table-hp-sim/m-p/4611717#M40563 PaulDoerr 2010-06-10T16:10:01Z