kace 1000 Device smart label Software Version
hello
Im trying to create a smart label where they have the same software but two different version installed.
like Outlook version 14 & 15
I have tried the following software title contains Microsoft Outlook and Software version matches regex 14, 15 without sucess
Any ideas?
thanks
Im trying to create a smart label where they have the same software but two different version installed.
like Outlook version 14 & 15
I have tried the following software title contains Microsoft Outlook and Software version matches regex 14, 15 without sucess
Any ideas?
thanks
3 Comments
[ + ] Show comments
-
Can you attach a screenshot of the two software programs in your software inventory. Along with what your existing Device Smart Label looks like? - jhawse 7 years ago
-
You use Outlook as an example but you seem to be asking about a general form of a query that would detect when multiple versions of any program is on a device. Is that accurate? - JasonEgg 7 years ago
-
yes thats correct, could be any software where there are more that one version on the machine - markc0 7 years ago
Answers (1)
Please log in to answer
Posted by:
JasonEgg
7 years ago
Office applications are kind of a pain since so many components have similar names. For example, if I search for "Microsoft Outlook" in my software inventory I get 575 results which include things like Microsoft KB patches (which are not actually the Outlook program). The query below looks for "Microsoft Outlook MUI" which may still return false positives:
SELECT M.NAME
,S.DISPLAY_NAME
,S.DISPLAY_VERSION
FROM MACHINE M
JOIN MACHINE_SOFTWARE_JT JT ON JT.MACHINE_ID = M.ID
JOIN SOFTWARE S ON JT.SOFTWARE_ID = S.ID
WHERE S.DISPLAY_NAME LIKE 'Microsoft Outlook MUI%'
AND S.PUBLISHER = 'Microsoft Corporation'
AND M.ID IN (
SELECT M.ID
FROM MACHINE M
JOIN MACHINE_SOFTWARE_JT JT ON JT.MACHINE_ID = M.ID
JOIN SOFTWARE S ON JT.SOFTWARE_ID = S.ID
WHERE S.DISPLAY_NAME LIKE 'Microsoft Outlook MUI%'
AND S.PUBLISHER = 'Microsoft Corporation'
GROUP BY M.ID
HAVING COUNT(S.DISPLAY_VERSION) > 1
)
ORDER BY M.NAME ASC
You also ask about a general form of this query that will return all software with multiple versions installed. Unfortunately, such a query would be either meaningless from so many false-positives or would be complicated and hard to manage. You saw the specificity I needed for Outlook; that's the process for pretty much any program you're interested in.
