Highlighted
Honored Contributor.
Honored Contributor.
330 views

How it fills the SaiVersionId and SoftwareCategoryId fields in ci type Installed Software

Jump to solution

Good day.
I want to understand how the ucmdb works to fill the fields SaiVersionId and SoftwareCategoryId, these fields are in the ci type installed software and are only used in the TQL AM Installed Software Push 2.0
I notice that each installed software discovered by the job Inventory by Scanner handles its own identification number (SaiVersionId)

Where do you get those values?

Thank you,

--------------------------------------------------------------

sai_version_id

SaiVersionId

integer

 The version ID of this installed software application from the Software Application Index (SAI) used to recognize the application.  

---------------------------------------------------------------

0 Likes
1 Solution

Accepted Solutions
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: How it fills the SaiVersionId and SoftwareCategoryId fields in ci type Installed Software

Jump to solution

Hi Marsella,

 

as you probably know, in order the installedsoftware to appear from the scanner file into the UCMDB, the processing passes through the so called XML Enricher. There all the discovered files which match specific rules (based on version or checksum) match with the SAI databases. The databases used can be found in DataFlowManagement -> SoftwareLibrary. There you can open Master.sai and find all the recognizable software. 

However you will not find the sai index ids there, because they are hidden behind the interface. In order to find the IDs, you need to export the zsai file, unarchive it (it is a gzip, so put a .gz extension) and open the file with text editor. Once you do that, you will find all the ids:

 

    <application id="39088" name="MySQL Shell" description="" apptypeid="122239">
      <release id="47503" name="1">
        <version id="68150" name="1.0.9" description="" osid="306" languageid="0" commercial="Free" matchallinstallstrings="true">
          <file id="7320466" name="mysqlprovision" type="Associated" size="279065" sizematters="True" exetype="Script" signature="ECC8-C9D5" />
          <file id="7320467" name="mysqlsh" type="Main" size="14505104" sizematters="True" exetype="Mach-O x86-64" signature="3A47-8A21" />
        </version>
        <version id="68480" name="1.0.10" description="" osid="306" languageid="0" commercial="Free" matchallinstallstrings="true">
          <file id="7337949" name="mysqlprovision" type="Associated" size="282575" sizematters="True" exetype="Script" signature="5C30-6935" />
          <file id="7337950" name="mysqlsh" type="Main" size="14258656" sizematters="True" exetype="Mach-O x86-64" signature="82D0-7A50" />
        </version>
        <version id="71047" name="1.0.11" description="" osid="306" languageid="0" commercial="Free" matchallinstallstrings="true">
          <file id="7479816" name="mysqlprovision" type="Associated" size="285967" sizematters="True" exetype="Script" signature="E544-A441" />
          <file id="7479817" name="mysqlsh" type="Main" size="14535664" sizematters="True" exetype="Mach-O x86-64" signature="F5F7-64AF" />
        </version>
      </release>
    </application>

Petko Popadiyski

Freelance UCMDB Consultant

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation. 

Likes are appreciated!

View solution in original post

3 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: How it fills the SaiVersionId and SoftwareCategoryId fields in ci type Installed Software

Jump to solution

Hi Marsella,

 

as you probably know, in order the installedsoftware to appear from the scanner file into the UCMDB, the processing passes through the so called XML Enricher. There all the discovered files which match specific rules (based on version or checksum) match with the SAI databases. The databases used can be found in DataFlowManagement -> SoftwareLibrary. There you can open Master.sai and find all the recognizable software. 

However you will not find the sai index ids there, because they are hidden behind the interface. In order to find the IDs, you need to export the zsai file, unarchive it (it is a gzip, so put a .gz extension) and open the file with text editor. Once you do that, you will find all the ids:

 

    <application id="39088" name="MySQL Shell" description="" apptypeid="122239">
      <release id="47503" name="1">
        <version id="68150" name="1.0.9" description="" osid="306" languageid="0" commercial="Free" matchallinstallstrings="true">
          <file id="7320466" name="mysqlprovision" type="Associated" size="279065" sizematters="True" exetype="Script" signature="ECC8-C9D5" />
          <file id="7320467" name="mysqlsh" type="Main" size="14505104" sizematters="True" exetype="Mach-O x86-64" signature="3A47-8A21" />
        </version>
        <version id="68480" name="1.0.10" description="" osid="306" languageid="0" commercial="Free" matchallinstallstrings="true">
          <file id="7337949" name="mysqlprovision" type="Associated" size="282575" sizematters="True" exetype="Script" signature="5C30-6935" />
          <file id="7337950" name="mysqlsh" type="Main" size="14258656" sizematters="True" exetype="Mach-O x86-64" signature="82D0-7A50" />
        </version>
        <version id="71047" name="1.0.11" description="" osid="306" languageid="0" commercial="Free" matchallinstallstrings="true">
          <file id="7479816" name="mysqlprovision" type="Associated" size="285967" sizematters="True" exetype="Script" signature="E544-A441" />
          <file id="7479817" name="mysqlsh" type="Main" size="14535664" sizematters="True" exetype="Mach-O x86-64" signature="F5F7-64AF" />
        </version>
      </release>
    </application>

Petko Popadiyski

Freelance UCMDB Consultant

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation. 

Likes are appreciated!

View solution in original post

Highlighted
Honored Contributor.
Honored Contributor.

Re: How it fills the SaiVersionId and SoftwareCategoryId fields in ci type Installed Software

Jump to solution

Thank you very much Mr. Petko

I complement the information:

http://cmshelpcenter.saas.hp.com/CMS/10.32/ucmdb-docs/docs/eng/doc_lib/Content/dfm/SAI_Filterzsai.htm 

Some idea of how to unarchive in windows:

Master.zsai.PNG

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: How it fills the SaiVersionId and SoftwareCategoryId fields in ci type Installed Software

Jump to solution

Change the .zsai to .gz and use 7zip, winzip or winrar to unrachive it. then open the resulting file with XML or test editor

Petko Popadiyski

Likes are appreciated!
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.