Hi,


So I have created a software smart label that identifies all "Real" installes of Microsoft Office in the software catalog.

pM5MmB.png

Now I would like to create a device smart label for any devices that have any of the identified software installed.

I'm stumped on how to proceed.

Answer Summary:
Cancel
2 Comments   [ + ] Show Comments

Comments

  • What is your overall aim with this process? What are you looking to achieve? It is easy to become confused between label types (Software/Device)
    • I want to be able to create a report listing all devices that have any of the labeled software installed.
      • From the look of it you want to figure out who has Microsoft Office Pro installed.Correct?
  • Yes. However because we are spread across 30 countries it has many different names it can go by (depending on language). And we have office xp, 2000, 2000-SR1, 2003, 2007, 2010 and 2013 to contend with
Please log in to comment

Answer Chosen by the Author

0
You might be able to handle this by utilizing a software asset. When you create a software asset you can associate a software label with the asset. The asset page will then list all of the computers that have that title installed. I'm not sure how you would get from the asset to a proper report, but it's a start.

Another thought: how difficult would it be to find all of the software titles for the various versions of Office you have across the inventory? If you can get a list of the IDs for those titles then creating a report or smart label would be easier.
Answered 06/26/2015 by: chucksteel
Red Belt

  • Can I do a managed install based on a software asset?
    • No, managed installs are tied to a software inventory item as they need to be tied to the specific version of software that is being installed by the managed install.
      • Can I tie a managed install to a software smart label?
        For instance, I have a Software Smart Label that detects all Adobe Flash Player older than 18.0.0.203. Can I direct a managed install to install 18.0.0.203 to all devices with software matching that smart label?
      • Yes. When you create the managed install it can target machines or a label, and that label can be a smart label. I have used this technique to deploy Flash as you are describing.
Please log in to comment

Answers

0
You can do something like this in a report....

select M.ID, M.NAME, SAM.NAME from SAM_VIEW_DISCOVERED_SOFTWARE SAM
left join SAM_MACHINE_JT SM on SM.SAM_CATALOG_ID = SAM.ID
left join MACHINE M on M.ID = SM.MACHINE_ID
where SAM.NAME like 'Microsoft Office%'
and SAM.NAME like '%Professional%'

This shows all machine ID's and Names as well as the Name of the software installed IF the software starts with Microsoft Office and has the word Professional on it. You will probably need to tweak this a little bit for the various versions and languages though. 
Answered 06/26/2015 by: h2opolo25
Red Belt

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