Query to get the assets added into assetexplorer today

Query to get the assets added into assetexplorer today

The below query can be used to get the assets which are added in assetexplorer today.

select res.resourcename "Device Name", cdef.componentname "Model", ct.componenttypename from resources res left join componentdefinition cdef on res.componentid=cdef.componentid left join componenttype ct on cdef.componenttypeid=ct.componenttypeid where res.resourceid in (select resourceid from resourcestatehistory where statehistoryid in (select min(STATEHISTORYID) from resourcestatehistory group by resourceid) and STARTTIME>=<from_today>) order by 3

Regards,
Balaguru.

              New to ADManager Plus?

                New to ADSelfService Plus?