Scripting Question

How to run a report with Devices and Assets

05/22/2018 488 views
We have some systems that are only in the asset part and NOT in devices. I have a monthly report that has to have ALL systems listed. I have a report as of now that has all the device, but I am missing a few per department because they are assets. How can I get the assets in the same report as the devices? The report has to look like this:VgfHAc.png
I am fine with the assets being empty on all other information, but I need them in the report. Would it be best to make labels and run a report based on the label? This is my TPS reports.  :(  
2 Comments   [ + ] Show comments


  • That image is unreadable for me (the forum tends to shrink images). Can you post an external link to the image or list what the report should show?
  • Why not just pull your report from the Asset Table? If what you are saying is that you have Asset records but no linked Inventory, that suggests the Inventory record has been deleted, leaving the asset record in place. If you never have an occasion when you have an inventory record and no associated record, just run your report from the ASSET Table saying where the ASSET_TYPE_ID is 5 to get devices and then use the ASSET_DATA_ID column to see/confirm if an inventory record is associated

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ