/build/static/layout/Breadcrumb_cap_w.png

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

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 6 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 6 years ago
  • yes thats correct, could be any software where there are more that one version on the machine - markc0 6 years ago

Answers (1)

Posted by: JasonEgg 6 years ago
Red Belt
0
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. 

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ