Absent Member.. monnewbie3 Absent Member..
Absent Member..
167 views

DDMI software tables different from ED2.51?

Hello,

We've upgraded from ED2.51 to DDMI7.61.

I've noticed that there are a lot more entries in the Application/Release/version tables, many of which have no device attached to it (therefore no installs on the network).

We've had to filter out many of the "null" entries so we can do proper reporting. In the version table there are about 23000 unique entries...in ED 2.51 we had about 3500 (but all of these had at least one install on the network).

Has anyone noticed a similar occurrence?

Thanks,
0 Likes
7 Replies
Jeff Sikorski Absent Member.
Absent Member.

Re: DDMI software tables different from ED2.51?

I cant speak to any changes HP might have made to their software tables in the past few versions. I'm not sure exactly what you are trying to do... but it seems like your joins in your queries are incorrect.

This is the query i use for software SAI data:
------------------------------------------

select
d.Device_LastScanTimeStamp as Inventory_Date,
d.device_DiscoveryRule as Location_based_off_IP,
d.device_scanfilename as Scan_File_Name,
hwNet.hwDomainName as Domain_Name,
hwNet.hwLocalMachineID as Machine_Name,
hwsmSI.hwsmbiosSystemSerialNumber as Serial_Number,
d.Device_Tag as Operating_System,
hwA.hwAssetEmployeeID as User_EMail_ID,
hwA.hwAssetDescription as Machine_Model,
hwCPUs.hwCPU as CPU_Type,
hwCPU.hwCPUCount as CPU_Count,
hwCPU.hwPhysicalCPUCount as Physical_CPU_Count,
hwCPU.hwCPUCoreCount as Core_CPU_Count,
d.device_preferredIPAddress as IP_Address,
d.device_preferredMACAddress as MAC_Address,
a.Application_Name as Application_Name,
c.Company_Name as Company_Name,
r.Release_Name as Release_Name,
v.Version_Name as Version_Name,
s.SWSubComponent_InstalledDirectory as Installed_Directory

from swsubcomponent s,
version v,
`release` r,
application a,
device d,
Company c,
hwSystemData sd,
hwBiosData hwB,
hwAssetData hwA,
hwCPUData hwCPU,
hwCPUs hwCPUs,
hwNetworkNames hwNet,
hwsmbiosSystemInformation hwsmSI


where
s.Version_ID = v.Version_ID
and v.Release_ID = r.Release_ID
and r.Application_ID = a.Application_ID
and a.Company_ID = c.Company_ID
and d.Device_ID = s.Device_ID
and d.Device_ID = sd.Device_ID
and d.Device_ID = hwB.Device_ID
and d.Device_ID = hwA.Device_ID
and d.Device_ID = hwCPU.Device_ID
and d.Device_ID = hwNet.Device_ID
and d.device_id = hwsmSI.Device_ID

-- there are multiple instances of device_ID in the hwCPUs table. These next 2 take the first instance.
and d.device_ID = hwCPUs.Device_ID
and hwCPUs.hwCPUs_Seq = 0
and d.device_status = 'Active'


and a.Application_Name = 'APPLICATION_NAME'
-- and c.company_name = 'COMPANY_NAME'
-- and r.Release_Name = '2007'
-- and v.version_name = 'XXX'


order by Machine_Name

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

That query will only pull back devices that have that specific application/company/release/version name...

~Jeff
0 Likes
Absent Member.. monnewbie3 Absent Member..
Absent Member..

Re: DDMI software tables different from ED2.51?

Hey Jeff,

Thanks for your reply.

In terms of hardware etc everything is fine.

But the software tables seem to be almost "pre loaded" with the versions from the SAI.

We're just wondering why there's over 20k entries in DDMI, when there was only just over 3k in ED 2.51.

We can filter out the null objects by matching the sub component table. However we just want to figure out how the Application/Release/Version tables are being populated.

Thanks,
0 Likes
Jeff Sikorski Absent Member.
Absent Member.

Re: DDMI software tables different from ED2.51?

If I do a:

select count(*) from version

on my database (v7.70), I see 32,873 records.

What query are you using?

~Jeff
0 Likes
Absent Member.. monnewbie3 Absent Member..
Absent Member..

Re: DDMI software tables different from ED2.51?

Hey Jeff,

We get similar results when we run the same query.

However, when we run the below query it links it to the device table which means a piece of software is actually installed somewhere on the network.. We get about 2900 versions back that we know are installed somewhere on the network.
I'm wondering if the version table comes pre-loaded with all the software?

USE aggregate;

SELECT c.Company_Name,
a.Application_Name,
r.Release_Name,
v.Version_Name
FROM swsubcomponent s
JOIN version v
ON s.Version_ID = v.Version_ID
JOIN `release` r
ON v.Release_ID = r.Release_ID
JOIN application a
ON r.Application_ID = a.Application_ID
JOIN company c
ON a.Company_ID = c.Company_ID
GROUP BY c.Company_Name,
a.Application_Name,
r.Release_Name,
v.Version_Name
ORDER BY 1,
2,
3,
4
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: DDMI software tables different from ED2.51?

monnewbie3,

Your observation is correct

DDMI 7.6x has brought in significant improvements to application recognition which continued in DDMI 7.70.

With the new features, the Publisher/Application/Release/Version information from the "active" SAIs (configured to be used during recognition) are now loaded into the database.

Regards,
Brindusa
0 Likes
Absent Member.. monnewbie3 Absent Member..
Absent Member..

Re: DDMI software tables different from ED2.51?

That's exactly what I needed to hear.

Thank you very much.

0 Likes
Absent Member.. monnewbie3 Absent Member..
Absent Member..

Re: DDMI software tables different from ED2.51?

.
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.