Can you fix this report.

Hi,

i have been working on the below report, can anyone take a look and let me know why it wont generate, there is nothing in the logs when i run it. it was working up until the network info was added.

SELECT workstation.WORKSTATIONNAME "Workstation",

workstation.MODEL "Model",

workstation.SERVICETAG "Service Tag",

dominf.DOMAINNAME "Domain Name",

state.DISPLAYSTATE "Asset State",

aaaUser.FIRST_NAME "User",

workstation.LOGGEDUSER "Last Logged In User",

networkinfo.IPADDRESS 'IPAddress' from SystemInfo sysi,

aaov.NAME "Site",LONGTODATE(AUDITHISTORY.AUDITTIME) "Last Successful Scan Date" FROM SystemInfo workstation

LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID

LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID

LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID

LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID

LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID

LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID

LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID

LEFT JOIN SystemInfoDomain sysInfod ON workstation.WORKSTATIONID=sysInfod.WORKSTATIONID

LEFT JOIN DomainInfo dominf ON sysInfod.DOMAINID=dominf.DOMAINID

LEFT JOIN audithistory on workstation.workstationid=audithistory.workstationid

LEFT JOIN networkinfo on sysi.WORKSTATIONID=networkinfo.WORKSTATIONID

LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID

WHERE ((audithistory.auditstatus='SUCCESS') AND (audithistory.auditid in (Select max(audithistory.auditid) from audithistory where audithistory.auditstatus = 'SUCCESS' group by workstationid)))

AND state.DISPLAYSTATE = 'In Use'

ORDER BY LONGTODATE(AUDITHISTORY.AUDITTIME)

Edit:

Build no is 11.2 Build 11202

built on PGSQL

i want the report to list every workstation in our asset register, the model, the service tag, the user assigned, the last logged in user, the site, and the last reporting IP address