Hi,

Please use the query below to get the report.
Login to ServiceDesk Plus, go to Reports > New Query report, copy the query to query editor and run the report.

SELECT productType.COMPONENTTYPENAME "Product Type",res.RESOURCENAME,longtodate(ResourceStateHistory.STARTTIME) 'Changed Date',aaa.FIRST_NAME 'Changed By',rstate.DISPLAYSTATE 'Previous State',ResourceState.DISPLAYSTATE 'Current State',AaaUser.FIRST_NAME 'Assigned User',DepartmentDefinition.DEPTNAME 'Assigned Dept' FROM ResourceStateHistory LEFT JOIN ResourceOwnerHistory ON ResourceStateHistory.STATEHISTORYID=ResourceOwnerHistory.STATEHISTORYID LEFT JOIN ResourceState ON ResourceStateHistory.RESOURCESTATEID=ResourceState.RESOURCESTATEID LEFT JOIN ResourceAssociationHistory ON ResourceOwnerHistory.RESOURCEOWNERID=ResourceAssociationHistory.RESOURCEOWNERID LEFT JOIN Resources ON ResourceAssociationHistory.ASSTTORESOURCEID=Resources.RESOURCEID LEFT JOIN SDUser ON ResourceOwnerHistory.USERID=SDUser.USERID LEFT JOIN AaaUser ON SDUser.USERID=AaaUser.USER_ID LEFT JOIN DepartmentDefinition ON ResourceOwnerHistory.DEPTID=DepartmentDefinition.DEPTID LEFT JOIN Resources res ON ResourceStateHistory.RESOURCEID=res.RESOURCEID LEFT JOIN ResourceState rstate ON
ResourceStateHistory.PREVRESOURCESTATEID=rstate.RESOURCESTATEID LEFT JOIN AaaUser aaa ON ResourceStateHistory.USERID=aaa.USER_ID LEFT JOIN ComponentDefinition product ON res.COMPONENTID=product.COMPONENTID LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID WHERE aaa.FIRST_NAME IS NOT NULL AND productType.COMPONENTTYPENAME like 'Workstation' AND ResourceState.DISPLAYSTATE like 'In Store' ORDER BY 1,2,3

Regards,
Stephen