Open-AudIT

What's on your network?
It is currently Mon Jan 22, 2018 8:30 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Report creation ?
PostPosted: Sat Feb 27, 2016 1:52 am 
Offline
Contributor

Joined: Thu May 03, 2007 10:38 am
Posts: 116
Location: Midwest
I created a report to pull the version of citrix receiver on PCs.

The one issue I see is I have duplicate hostnames for some PCs. Any help would be great.

Example
PC1 Citrix Receiver 14.3.100.10
PC1 Citrix Receiver 14.4.0.8014
PC1 Citrix Receiver 14.3.100.10


Here is my code
<?xml version="1.0" encoding="ISO-8859-1"?>
<report>
<details>
<report_name>Installed - Citrix Receiver</report_name>
<report_display_in_menu>y</report_display_in_menu>
<report_sql><![CDATA[SELECT system.system_id, system.hostname, software.name, software.version FROM software LEFT JOIN system ON (system.system_id = software.system_id AND software.name = 'Citrix Receiver') JOIN oa_group_sys ON (system.system_id = oa_group_sys.system_id) WHERE oa_group_sys.group_id = @group]]></report_sql>
<report_display_sql></report_display_sql>
<report_view_file>v_report</report_view_file>
<report_view_contents></report_view_contents>
<report_processing></report_processing>
<report_sort_column>0</report_sort_column>
<report_description>Name, software name, software version where software_name like Citrix Receiver.</report_description>
</details>
<columns>
<column>
<column_order>0</column_order>
<column_name>System Name</column_name>
<column_variable>hostname</column_variable>
<column_type>link</column_type>
<column_link>/main/system_display/</column_link>
<column_secondary>system_id</column_secondary>
<column_align>left</column_align>
</column>
<column>
<column_order>1</column_order>
<column_name>Software Name</column_name>
<column_variable>name</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_align>left</column_align>
</column>
<column>
<column_order>2</column_order>
<column_name>Version</column_name>
<column_variable>version</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_align>left</column_align>
</column>
</columns>
</report>


Top
 Profile  
Reply with quote  
 Post subject: Re: Report creation ?
PostPosted: Sat Feb 27, 2016 3:18 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1226
From your table names I see you're on a recent OpenAudit build. So you need a "WHERE software.current = 'y'" in there to get only the most recent software audit info.


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

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 4 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:  
Powered by phpBB® Forum Software © phpBB Group