Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Fri Mar 29, 2024 9:14 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
PostPosted: Thu Jan 04, 2007 12:19 am 
Offline
Newbie

Joined: Fri Jul 07, 2006 6:07 am
Posts: 10
Location: Ohio
Hi All,

I've been using Winventory/OpenAudit for awhile now. Awesome product!! Great job to all those that have helped and contributed over the projects life!

I recently implemented OpenAudit in a new organization and one of the features that would be very helpful is to list or search for service tags. We get Dell notices often that warn us of pending expiration of service contracts, but they usually show the "item" as "Server" or "Workstation" instead of some useful information.

Is there any way to add a page in the queries that would list the systems, manufacture, and bios serial number?

thanks,
Eric Jensen


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Thu Jan 04, 2007 1:58 am 
Copy this into a file such as list_viewdef_serials.php or whatever you like. Access it by going to "list.php?view=serials". The name of the file doesn't matter, as long as it starts with list_viewdef_ and then whatever follows (minus the .php) is sent as a parameter to list.php.

[code]<?php

$query_array=array("headline"=>__("List all Systems"),
"sql"=>"SELECT * FROM `system`",
"sort"=>"system_name",
"dir"=>"ASC",
"get"=>array("file"=>"system.php",
"title"=>__("Go to System"),
"var"=>array("pc"=>"%system_uuid",
"view"=>"summary",
),
),
"fields"=>array("10"=>array("name"=>"system_uuid",
"head"=>__("UUID"),
"show"=>"n",
),
"30"=>array("name"=>"system_name",
"head"=>__("Hostname"),
"show"=>"y",
"link"=>"y",
),
"40"=>array("name"=>"system_vendor",
"head"=>__("Vendor"),
"show"=>"y",
"link"=>"y",
),
"50"=>array("name"=>"system_model",
"head"=>__("Model"),
"show"=>"y",
"link"=>"y",
),
"60"=>array("name"=>"system_id_number",
"head"=>__("Serial"),
"show"=>"y",
"link"=>"y",
),
"80"=>array("name"=>"system_timestamp",
"head"=>__("Date Audited"),
"show"=>$show_date_audited,
),
"90"=>array("name"=>"system_system_type",
"head"=>__("System Type"),
"show"=>$show_type,
"align"=>"center",
),

),
);
?>[/code]


Top
  
Reply with quote  
 Post subject:
PostPosted: Thu Jan 04, 2007 2:23 am 
Offline
Newbie

Joined: Fri Jul 07, 2006 6:07 am
Posts: 10
Location: Ohio
thanks for putting that together! works like a champ :D


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Thu Jan 04, 2007 2:28 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
Probably worth adding to the menu.
8)


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Thu Jan 04, 2007 3:15 am 
Offline
Newbie

Joined: Fri Jul 07, 2006 6:07 am
Posts: 10
Location: Ohio
yeah, great idea. how do i do that? or is that something done within the SVN build?


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Thu Jan 04, 2007 3:27 am 
You can add it to include_menu_array.php. Should be largely self-explanatory based on what's there, but let us know if that's not the case!

I don't know about adding it to SVN. The list is getting pretty long. I think we would need to figure out another method of displaying these queries.


Top
  
Reply with quote  
 Post subject:
PostPosted: Thu Jan 04, 2007 3:43 am 
Offline
Newbie

Joined: Fri Jul 07, 2006 6:07 am
Posts: 10
Location: Ohio
ok, will look at adding it to the menu_array page. one thought might be a section that allows users to add custom links. or even a custom query builder page. that would be amazing. :D


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 

All times are UTC + 10 hours


Who is online

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