How do I write a report or query to pull information from both Workstation data and also Asset data. I need to get a data file that shows Workstation Name, Beds Code (custom field added to Workstation form), Product Type (such as Desktop-PC, Desktop-MAC). The state requires us to pull all Product type related to computers and list quantities based on location (Beds Code field we added).
Is there a way to pull data like this and if so how?
I used Crystal reports before but I cannot use this with SDPLUS, any help would be appreciated.