Open-AudIT

What's on your network?
It is currently Sat Apr 21, 2018 6:07 am

All times are UTC + 10 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: Mon Jan 06, 2014 7:24 pm 
Offline
Newbie

Joined: Wed Aug 01, 2012 5:49 pm
Posts: 33
Location: NRW, Germany
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


Top
 Profile  
Reply with quote  
PostPosted: Tue Jan 07, 2014 10:38 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
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).

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Tue Jan 07, 2014 4:57 pm 
Offline
Newbie

Joined: Wed Aug 01, 2012 5:49 pm
Posts: 33
Location: NRW, Germany
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>


Attachments:
1.JPG
1.JPG [ 32.29 KiB | Viewed 2474 times ]
Top
 Profile  
Reply with quote  
PostPosted: Wed Jan 08, 2014 7:40 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
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.

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group