Open-AudIT
https://www.open-audit.org/phpBB3/

Software_Keys Management?
https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6256
Page 1 of 1

Author:  Mr.Gorillaz [ Mon Jan 06, 2014 7:24 pm ]
Post subject:  Software_Keys Management?

Hallo,

Is there any way to edit some Informationen to the Software Keys in OpenAudit?
It shows me how many installations with this Keys are used.
Now I want to Edit some Information e.g. how many lincenses I really have to this Key.

e.g. a Report-Table like this

[Systemcount][Licensed][Keyname][KeyText]

I would realy love this feature :P

Author:  Mark [ Tue Jan 07, 2014 10:38 am ]
Post subject:  Re: Software_Keys Management?

Software Licensing in Open-AudIT relates to what software is installed, not what licenses are gathered.
In a perfect world, your license count would match the software install counts, but we can't get every single license key.
I would suggest you use the Software Licensing Report (function) and use the License Keys as something to verify against (manually).

Author:  Mr.Gorillaz [ Tue Jan 07, 2014 4:57 pm ]
Post subject:  Re: Software_Keys Management?

Thats what I want to do.
I want to manually edit information to a Software Key for Verification.

eg.

System Count: 56
Aviable Licenses: 100 *manually Added*
Key NAME: Microsoft Office Standard 2007
Key Text: XXXXX-XXXXX-XXXXX-XXXXX-XXXXX



This should be Possible if you add a coloumn in the sys_sw_software_key - Table e.g. called "Key_aviable".

Then you could get this Value out of a Report and it would be very nice if you could edit this value in the edit function of OA:)


Edit:
I made somethink like I discriped on my own.

I did this:

Create the Coloumn:

alter table sys_sw_software_key ADD license_max varchar(50);

Edit your Values for the key:

Update sys_sw_software_key set license_max = 15 where key_text = 'xxxxx-xxxxx-xxxxx-xxxxx-xxxxx';

Edit your Report:
[code]
<?xml version="1.0" encoding="ISO-8859-1"?>
<report>
<details>
<report_name>Software Keys_new</report_name>
<report_description></report_description>
<report_display_in_menu>y</report_display_in_menu>
<report_sql><![CDATA[SELECT COUNT(key_text) as count, key_name, key_text, license_max, key_id FROM system LEFT JOIN oa_group_sys ON system.system_id = oa_group_sys.system_id LEFT JOIN sys_sw_software_key ON (sys_sw_software_key.system_id = system.system_id and sys_sw_software_key.timestamp = system.timestamp) WHERE oa_group_sys.group_id = @group GROUP BY key_text ORDER BY key_name]]></report_sql>
<report_view_file>v_report</report_view_file>
<report_view_contents></report_view_contents>
<report_processing></report_processing>
<report_sort_column>1</report_sort_column>
</details>
<columns>
<column>
<column_order>0</column_order>
<column_name>System Count</column_name>
<column_variable>count</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>center</column_align>
</column>
<column>
<column_order>0</column_order>
<column_name>License Max</column_name>
<column_variable>license_max</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>center</column_align>
</column>
<column>
<column_order>0</column_order>
<column_name>Key Name</column_name>
<column_variable>key_name</column_variable>
<column_type>link</column_type>
<column_link>/report/specific_key_name/$group_id/</column_link>
<column_secondary>key_id</column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<column_order>2</column_order>
<column_name>Key Text</column_name>
<column_variable>key_text</column_variable>
<column_type>link</column_type>
<column_link>/report/specific_key_text/$group_id/</column_link>
<column_secondary>key_text</column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
</columns>
</report>
[/code]

Attachments:
1.JPG
1.JPG [ 32.29 KiB | Viewed 6043 times ]

Author:  Mark [ Wed Jan 08, 2014 7:40 am ]
Post subject:  Re: Software_Keys Management?

The problem is that the key name (in sys_sw_software_key) and the software name (in sys_sw_software) do not necessarily match up.
And they never match if you use a language in Windows other than English.
If the key name did actually match what is retrieved from the registry and WMI for installed programs we could do it. It doesn't.

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/