what table has software productname ?
Created: 04 Sep 2012 | 4 comments
ok in NS6 there was the infamous
From [inv_aex_sw_audit_software] a
where a.[ProductName] like '%ezchrom%' and a.[file name] = 'helpmail.exe'
now in the 7.1sp2 world.. i have 99.99% of my items created.. but the .01% i just cant seem to figure out..
I was able to use Inv_Installed_File_Details for some like Name and path..
but ProductName doesnt exist...
I need to know where this can be found as we also have other items that we will be creating in the future off of that field...
If there is a way to do it via app metering or software in the catalog I can set it up but for now im lost as I have checked most of the tables with the simple
select * from dbo.tablename and not finding it...
now I have a feeling that someone will recommend a custom data class.. ok I could do that and I have created a few custom inventories... but kicker is that there is no specific file to say inventory on or i would use 'name' or even 'path'