Page 1 of 1

Link software to computer

PostPosted: Wed Apr 25, 2007 11:30 am
Can anyone tell me how to link both allocated and discovered software to a computer? I have tried every table that I could find relating to software and I cannot figure out the linking. I have checked the documentation that comes with the software. Thank you!

PostPosted: Fri Apr 27, 2007 12:27 pm
by pille
You're going to want to use the following database views.


and then in Crystal Reports link the Object_ID field from Discovered_Software_Product_List to the ID field in Computer_List_All

That should do it.

PostPosted: Fri Apr 27, 2007 12:29 pm
by pille
Oh, and I believe if you wanted to see allocated then you'd use the same methods with the view for allocated objects: