Open-AudIT

What's on your network?
It is currently Thu Jul 19, 2018 8:26 am

All times are UTC + 10 hours




Post new topic Reply to topic  [ 12 posts ] 
Author Message
PostPosted: Tue Jul 19, 2011 2:58 am 
Offline
Helper

Joined: Fri Feb 19, 2010 1:02 am
Posts: 67
Location: Washington State, USA
The beta does not seem to handle name changes for a computer. If I change the name of a computer it adds a new one, and then I have to delete the computer with the old name.

In OAv1 it would just update the name of the existing computer record.

This is not a huge deal, but it was nice because then I wouldn't have to update all the info if I had to change the computer name (eg: owner, purchase date, location, warranty length, and whatnot).

_________________
Server Info:
OA: v1.0.3
OS: Ubuntu 13.04 on Hyper-V for Website (LAMP)
OS: Windows Server 2008 R2 for Script (Domain Server)
Auditing: 366 Machines (XP/Win7/Ubuntu)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Tue Jul 19, 2011 3:49 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
For some reason Mark put the computer name in the system identifier key. Not sure what the reasoning is but maybe that's not such a good idea for obvious reasons.

I've been playing around with OAv2 but haven't switched to using it for our production auditing. So there might be a perfectly valid reason for this. Perhaps he was getting duplicates using the UUID alone. We use MAC address in OAv1 because the UUID caused problems. No such provision in OAv2.


Top
 Profile  
Reply with quote  
PostPosted: Wed Jul 20, 2011 3:42 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1956
Location: Brisbane, Australia
The unique id for a system is the computer name + UUID.
How ofter do you rename a PC ?
If it is renamed, is it re-imaged ?

If I use UUID, on white boxes it causes problems. They are often not set, set as all F's, etc, etc.

If I use MAC Address, these change. Think virtual machines. Think multiple NICs, etc, etc.

If I use hostname, these change.

The idea was to get something that was both (relatively) static and unique. Hostname + UUID for most people will be a unique combination.

I have found when a PC is renamed, it is usually also reimaged. In that case (in my opinion) it IS a new PC. You can use the "export system details" report to extract the old data, then reimport it after the "new" system has been audited.

Again - are you renaming PCs often enough that this is actually an issue ?
I'd be interested in your use-case for that. It may just make me change how I uniquely identify a system...

_________________
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: Thu Jul 21, 2011 2:36 am 
Offline
Helper

Joined: Fri Feb 19, 2010 1:02 am
Posts: 67
Location: Washington State, USA
We don't do it supper often, but like you said, we do it when it is re-imaged or re-purposed. We are a Dell shop for the most part so the UUID issue really hasn't come up for us, but I can see your problem.

It was just easier for us have the name change automatically.

I am wondering if this would be a good thing to be configurable? In the audit config have people pick what they want to identify their computers by?

With like three options: UUID, UUID + Name, MAC.

_________________
Server Info:
OA: v1.0.3
OS: Ubuntu 13.04 on Hyper-V for Website (LAMP)
OS: Windows Server 2008 R2 for Script (Domain Server)
Auditing: 366 Machines (XP/Win7/Ubuntu)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Thu Jul 21, 2011 5:19 am 
Offline
Contributor
User avatar

Joined: Thu Mar 02, 2006 4:41 am
Posts: 205
Location: Massachusetts
We usually rename and re-image, for the record. But this would affect a small percentage of systems here anyway.

_________________
Server Info: running on a CentOS 7 vm
OA Version: 2.0.6 @ 500 devices


Top
 Profile  
Reply with quote  
PostPosted: Thu Aug 11, 2011 8:33 am 
Offline
Helper

Joined: Fri Feb 19, 2010 1:02 am
Posts: 67
Location: Washington State, USA
I know this is an old thread but to manage duplicate computer names I created a group with the following SQL statement:

SELECT
system.system_id,
system.uuid,
count(*) as cnt
FROM
system
WHERE
system.system_id = system.system_id AND
system.man_status = 'production' AND
system.timestamp = system.timestamp GROUP BY uuid HAVING cnt > 1

This shows me computers with duplicate names, so I can deal with them accordingly.

Thanks,

-Shmee

_________________
Server Info:
OA: v1.0.3
OS: Ubuntu 13.04 on Hyper-V for Website (LAMP)
OS: Windows Server 2008 R2 for Script (Domain Server)
Auditing: 366 Machines (XP/Win7/Ubuntu)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Wed Aug 17, 2011 12:39 am 
Offline
Contributor

Joined: Wed Apr 07, 2010 8:04 am
Posts: 101
Location: Boston, MA
On OAv1, it was very helpful running the reports based on number of systems (physical boxes), but we were definitively missing having a historical record whenever a computer was re imaged.

I liked the fact that in OAv2 you do have that historical record of the old computer, but it makes running the reports a little bit more difficult, ideally, if the status could change from Production to Retired when a duplicate system is found, that would fix the problem.

The only thing is that once a system is -Retired-, I can't find it again in OAv2.

_________________
Old OA Setup: 500 Windows 7 workstations & 200 Apple OSX with OA v1.5.2 on Windows Server 2003 and WAMP 2
New OA Setup: 100 Windows servers with OA 2.2 on Windows Server 2016 and WAMP 3


Top
 Profile  
Reply with quote  
PostPosted: Wed Aug 17, 2011 3:36 am 
Offline
Helper

Joined: Fri Feb 19, 2010 1:02 am
Posts: 67
Location: Washington State, USA
I am not totally sure how the new built in reporting works for OAv2 but I am sure if you look in to it you can create a report that includes the retired flag, or you could easily create a custom group with SQL like I did a couple of replies previous to this one.

You can also do what we do here and use an outside reporting tool to look up the info you need. We use Excel (for one time reports) or JasperReports to query all kinds of fun reports, and all you would need to do is brush up on your SQL.

-Shmee

_________________
Server Info:
OA: v1.0.3
OS: Ubuntu 13.04 on Hyper-V for Website (LAMP)
OS: Windows Server 2008 R2 for Script (Domain Server)
Auditing: 366 Machines (XP/Win7/Ubuntu)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Wed Aug 17, 2011 8:34 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1956
Location: Brisbane, Australia
Here's a group definition for "NonProduction" systems.
Put it in a text file called NonProduction.xml and put the file in \code_igniter\system\application\controllers\groups
Then go to Admin -> Groups -> Activate Group.
Bingo!

Code:
<?xml version="1.0" encoding="ISO-8859-1"?>
<group>
   <details>
      <group_name>NonProduction Systems</group_name>
      <group_padded_name></group_padded_name>
      <group_dynamic_select>SELECT distinct(system.system_id) FROM system WHERE system.man_status != 'production'</group_dynamic_select>
      <group_parent>1</group_parent>
      <group_description>NonProduction Systems</group_description>
      <group_category>os</group_category>
      <group_display_sql>SELECT system.system_id, system.hostname, system.man_description, system.man_ip_address, system.timestamp, system.man_os_family, system.man_os_name, system.man_icon, system.man_manufacturer, system.man_model FROM system, oa_group_sys WHERE system.system_id = oa_group_sys.system_id AND oa_group_sys.group_id = ? GROUP BY system.system_id</group_display_sql>
      <group_icon>device</group_icon>
   </details>
   <columns>
      <column>
         <column_order>1</column_order>
         <column_name>Hostname</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_ternary></column_ternary>
         <column_align>left</column_align>
      </column>
      <column>
         <column_order>2</column_order>
         <column_name>Description</column_name>
         <column_variable>man_description</column_variable>
         <column_type>text</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align>left</column_align>
      </column>
      <column>
         <column_order>3</column_order>
         <column_name>IP Address</column_name>
         <column_variable>man_ip_address</column_variable>
         <column_type>ip_address</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align>left</column_align>
      </column>
      <column>
         <column_order>4</column_order>
         <column_name>Last Audit</column_name>
         <column_variable>timestamp</column_variable>
         <column_type>text</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align>right</column_align>
      </column>
      <column>
         <column_order>5</column_order>
         <column_name>OS</column_name>
         <column_variable>man_os_family</column_variable>
         <column_type>text</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align>right</column_align>
      </column>
   </columns>
</group>

_________________
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: Wed Aug 17, 2011 10:07 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1956
Location: Brisbane, Australia
Here's a report definition for "Duplicate UUID" systems.
Put it in a text file called DuplicateUUID.xml and put the file in \code_igniter\system\application\controllers\reports
Then go to Admin -> Reports -> Activate Report.
Bingo!


Code:
<?xml version="1.0" encoding="ISO-8859-1"?>
<report>
   <details>
      <report_name>Duplicate UUIDs</report_name>
      <report_display_in_menu>y</report_display_in_menu>
      <report_sql>SELECT system.system_id, system.uuid, system.hostname, system.man_description, system.man_ip_address, system.timestamp, system.man_os_family, pc_date_os_installation FROM system LEFT JOIN oa_group_sys ON system.system_id = oa_group_sys.system_id WHERE oa_group_sys.group_id = ? AND system.uuid IN ( SELECT system.uuid FROM system GROUP BY system.uuid HAVING (COUNT(system.uuid) > 1) ) </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>
   </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_ternary></column_ternary>
         <column_align></column_align>
      </column>
      <column>
         <column_order>1</column_order>
         <column_name>IP Address</column_name>
         <column_variable>man_ip_address</column_variable>
         <column_type>ip_address</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align></column_align>
      </column>
      <column>
         <column_order>2</column_order>
         <column_name>Description</column_name>
         <column_variable>man_description</column_variable>
         <column_type>text</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align></column_align>
      </column>
      <column>
         <column_order>3</column_order>
         <column_name>UUID</column_name>
         <column_variable>uuid</column_variable>
         <column_type>text</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align></column_align>
      </column>
      <column>
         <column_order>4</column_order>
         <column_name>Last Audit</column_name>
         <column_variable>timestamp</column_variable>
         <column_type>text</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align></column_align>
      </column>
      <column>
         <column_order>5</column_order>
         <column_name>OS Installed</column_name>
         <column_variable>pc_date_os_installation</column_variable>
         <column_type>text</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align></column_align>
      </column>
      <column>
         <column_order>6</column_order>
         <column_name>OS</column_name>
         <column_variable>man_os_family</column_variable>
         <column_type>text</column_type>
         <column_link></column_link>
         <column_secondary></column_secondary>
         <column_ternary></column_ternary>
         <column_align></column_align>
      </column>
   </columns>
</report>

_________________
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: Thu Aug 18, 2011 12:24 am 
Offline
Helper

Joined: Fri Feb 19, 2010 1:02 am
Posts: 67
Location: Washington State, USA
Thanks for the report!

-Shmee

_________________
Server Info:
OA: v1.0.3
OS: Ubuntu 13.04 on Hyper-V for Website (LAMP)
OS: Windows Server 2008 R2 for Script (Domain Server)
Auditing: 366 Machines (XP/Win7/Ubuntu)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Thu Aug 18, 2011 10:20 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1956
Location: Brisbane, Australia
Quote:
You can also do what we do here and use an outside reporting tool to look up the info you need. We use Excel (for one time reports) or JasperReports to query all kinds of fun reports, and all you would need to do is brush up on your SQL.


Hey Shmee, what reports would you like that aren't available out-of-the-box ? I have no problem's creating reports (even custom report's that would not be useful for others) that people want/need. I'll start another thread and ask for comments.

_________________
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  [ 12 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 3 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