I am trying to use Kace to create a report to see what PCs in my company have Microsoft Map Point on them and I am not sure how to do a join on the 2 SQL databases. Can anyone help me here. I know that software and hardware are on 2 different DBs, i just do not know how to join those 2 DBs in code so I can generate a report that tells me which of the PCs in my company have Map POint and if I can tell the last time it was used. I am new to Kace so I hope I am asking this correctly. let me know if you need any more info. Thank you.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Software is stored in SOFTWARE and machines are stored in MACHINE -- both in the same database (ORG1 for most customers, ORGX for some)

Since a piece of software can be on many machines and a machine can have many pieces of software you will join them through MACHINE_SOFTWARE_JT

The easiest thing to do is create a report and dissect the SQL. Or view some of the example reports in the kb, appdeploy or canned in the kbox

One for this question:

select M.NAME PC FROM MACHINE M JOIN MACHINE_SOFTWARE_JT MS ON MS.MACHINE_ID=M.ID JOIN SOFTWARE S ON S.ID=MS.SOFTWARE_ID
WHERE S.DISPLAY_NAME LIKE '%map point%'
Answered 10/12/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity