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 |
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]
|
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/ |