Asset Reports with specific fields (not appearing) in Custom Reports Choices
I am trying to make a custom report for my assets.
The problem is that I cannot select some fields that I need.
Here is the Original Query
SELECT MAX(workstation.WORKSTATIONNAME) AS "Workstation",
MAX(compGrps.NAME) AS "Computer Group",
MAX(chassisType.NAME) AS "Chassis Type",
MAX(workstation.MODEL) AS "Model",
MAX(product.COMPONENTNAME) AS "Product",
MAX(workstation.SERVICETAG) AS "Service Tag",
MAX(aaaUser.FIRST_NAME) AS "User",
MAX(workstation.LOGGEDUSER) "Last Logged In User",
MAX(deptDef.DEPTNAME) AS "Department",
MAX(state.DISPLAYSTATE) AS "Asset State" FROM SystemInfo workstation
LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID
LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID
LEFT JOIN ComponentDefinitionComputer compDefComputer ON product.COMPONENTID=compDefComputer.COMPONENTID
LEFT JOIN ComputerGroups compGrps ON compDefComputer.COMPUTERGROUPID=compGrps.ID
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 DepartmentDefinition deptDef ON rOwner.DEPTID=deptDef.DEPTID
LEFT JOIN ChassisTypes chassisType ON resource.CHASSISTYPEID=chassisType.ID WHERE (ISSERVER='0') GROUP BY workstation.WORKSTATIONID
But when trying to do the same with other scripts I only get errors in the log Window or just nothing comes.
If the query is made correctly I can see the report. I am struggling with this for a long time and finally decided to ask for the community's help!
If somebody can help, I would be very grateful.
The additional fields I need are the following
From Asset Details Section
Last Contact Time
Last Boot Time
From User Details Section
Is Loaned
From Hardware Section
IP Address
and finally
Last Scan Date
Last Success Scan Date
Scan Status
All these fields in one single report would be great for me
Thanks in advance for any help provided.
Christian VEGA