Relation between Inv_ClientTasks and SWDPackage
I need a report where I see the following informations:
Hostname - installed Software (including version, edition, service pack) - packagename - package location
Actually I found the table Inv_ClientTasks for a lot of my needed Infos. Furthermore I found in SWDPackage the Package Location.
Unfortunately I dont find any relation bewtween Inv_ClientTasks and SWDPackage.
Does anybody has an idea?
Maybe a better table / view to get all these informations?
These informations above mentionend are a small extract of my needed infos :-)
Where I can find a database diagram where I can see all relations between the tables?