Open-AudIT • View topic - Beta doesn't handle name changes.

View unanswered posts | View active topics

Board index » Open-AudIT » Discussion

All times are UTC + 10 hours

Beta doesn't handle name changes.

Page 1 of 1

[ 12 posts ]

Print view

Previous topic | Next topic

Author

Message

Shmee

Post subject: Beta doesn't handle name changes.

Posted: Tue Jul 19, 2011 2:58 am

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

jpa

Post subject: Re: Beta doesn't handle name changes.

Posted: Tue Jul 19, 2011 3:49 am

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

Mark

Post subject: Re: Beta doesn't handle name changes.

Posted: Wed Jul 20, 2011 3:42 pm

Site Admin

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

Shmee

Post subject: Re: Beta doesn't handle name changes.

Posted: Thu Jul 21, 2011 2:36 am

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.

Top

shanimal

Post subject: Re: Beta doesn't handle name changes.

Posted: Thu Jul 21, 2011 5:19 am

Contributor

Joined: Thu Mar 02, 2006 4:41 am
Posts: 204
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

Shmee

Post subject: Re: Beta doesn't handle name changes.

Posted: Thu Aug 11, 2011 8:33 am

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

Top

el_geto

Post subject: Re: Beta doesn't handle name changes.

Posted: Wed Aug 17, 2011 12:39 am

Helper

Joined: Wed Apr 07, 2010 8:04 am
Posts: 99
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.

_________________
OA v1.5.2 on Windows Server 2003 and WAMP 2.0 (Apache 2.2.22, PHP 5.4.3, MySQL 5.1.36).
OA v1.5.3 on Linux
Auditing 500 Windows 7 computers via GPO, 200 Apple OSX 10.8/10.9/10.10

Top

Shmee

Post subject: Re: Beta doesn't handle name changes.

Posted: Wed Aug 17, 2011 3:36 am

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

Top

Mark

Post subject: Re: Beta doesn't handle name changes.

Posted: Wed Aug 17, 2011 8:34 am

Site Admin

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

Mark

Post subject: Re: Beta doesn't handle name changes.

Posted: Wed Aug 17, 2011 10:07 am

Site Admin

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

Shmee

Post subject: Re: Beta doesn't handle name changes.

Posted: Thu Aug 18, 2011 12:24 am

Helper

Joined: Fri Feb 19, 2010 1:02 am
Posts: 67
Location: Washington State, USA

Thanks for the report!

-Shmee

Top

Mark

Post subject: Re: Beta doesn't handle name changes.

Posted: Thu Aug 18, 2011 10:20 am

Site Admin

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

Page 1 of 1

[ 12 posts ]

Board index » Open-AudIT » Discussion

All times are UTC + 10 hours

Who is online

Users browsing this forum: No registered users and 1 guest

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