Open-AudIT

What's on your network?
It is currently Wed Apr 25, 2018 7:04 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 16 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: phpmyadmin queries
PostPosted: Thu Aug 24, 2006 2:24 am 
Offline
Helper

Joined: Fri Jan 13, 2006 8:40 am
Posts: 66
Location: New Jersey
Hi,
We just installed phpmyadmin to try to export from mysql. We are NOT dbas. We need to export a report for software installed by computer name. Does anyone have this to share?

_________________
Windows Server 2003, Apache 2.0.59, PHP 5.14, MySQL 5.0.22


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 3:23 am 
Offline
Moderator

Joined: Sun Aug 06, 2006 1:13 am
Posts: 362
Location: Germany
With this query, you get all actuall installed software with hostnames and the date of the last scan.


Code:
SELECT system_name, software_name, software_version, software_publisher, software_url, software_timestamp
FROM software, system
WHERE software_name NOT LIKE '%hotfix%'
AND software_name NOT LIKE '%update%'
AND software_name NOT LIKE '%Service Pack%'
AND software_uuid = system_uuid
AND software_timestamp = system_timestamp


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 3:24 am 
I believe this will be your query:
Code:
SELECT `system`.`system_name` , `software`.`software_name`
FROM system, software
WHERE (
(
`software`.`software_uuid` = `system`.`system_uuid`
)
AND (
`software`.`software_timestamp` = `system`.`system_timestamp`
)
)
ORDER BY `system`.`system_name` ASC


In phpMyAdmin, you'll see a button labelled "sql." Click that and enter the above as your query. Click go, and you'll see the results (30 per page). On the bottom there is a labelled "Export." Click that and you'll have options on how to export!


Top
  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 3:25 am 
You can probably find a way to combine matze's and mine to have a better query!


Top
  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 3:59 am 
Offline
Helper

Joined: Fri Jan 13, 2006 8:40 am
Posts: 66
Location: New Jersey
mikeyrb wrote:
I believe this will be your query:
Code:
SELECT `system`.`system_name` , `software`.`software_name`
FROM system, software
WHERE (
(
`software`.`software_uuid` = `system`.`system_uuid`
)
AND (
`software`.`software_timestamp` = `system`.`system_timestamp`
)
)
ORDER BY `system`.`system_name` ASC


In phpMyAdmin, you'll see a button labelled "sql." Click that and enter the above as your query. Click go, and you'll see the results (30 per page). On the bottom there is a labelled "Export." Click that and you'll have options on how to export!


Mikeyrb,
I tried your query and I received same system, same software duplicates. Does this have to do with Ahull's post "Multiple instances of the same software on the same PC"??

_________________
Windows Server 2003, Apache 2.0.59, PHP 5.14, MySQL 5.0.22


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 4:36 am 
Offline
Helper

Joined: Fri Jan 13, 2006 8:40 am
Posts: 66
Location: New Jersey
matze wrote:
With this query, you get all actuall installed software with hostnames and the date of the last scan.


Code:
SELECT system_name, software_name, software_version, software_publisher, software_url, software_timestamp
FROM software, system
WHERE software_name NOT LIKE '%hotfix%'
AND software_name NOT LIKE '%update%'
AND software_name NOT LIKE '%Service Pack%'
AND software_uuid = system_uuid
AND software_timestamp = system_timestamp



Matze,
I am also receiving same system, same software duplicates using your query.

_________________
Windows Server 2003, Apache 2.0.59, PHP 5.14, MySQL 5.0.22


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 4:58 am 
Can you paste a line from phpyMyAdmin that shows duplicate items?

I'm looking for this info:
software_id software_uuid software_name software_version software_location software_uninstall software_install_date software_publisher software_install_source software_system_component software_url software_comment software_count software_timestamp software_first_timestamp


Top
  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 6:49 am 
Offline
Helper

Joined: Fri Jan 13, 2006 8:40 am
Posts: 66
Location: New Jersey
mikeyrb wrote:
Can you paste a line from phpyMyAdmin that shows duplicate items?

I'm looking for this info:
software_id software_uuid software_name software_version software_location software_uninstall software_install_date software_publisher software_install_source software_system_component software_url software_comment software_count software_timestamp software_first_timestamp


I'm sorry, I don't understand what you're looking for. I've been looking through the results from the query in the preview in phpmyadmin for dups, but I don't think that's what you're looking for.

When I click on a system name in OA, it will list one instance each of the software on that box. When I click on a piece of software in OA, It will list multple audits of the same system name. This issue reminds me of that.

_________________
Windows Server 2003, Apache 2.0.59, PHP 5.14, MySQL 5.0.22


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 7:15 am 
Offline
Moderator

Joined: Sun Aug 06, 2006 1:13 am
Posts: 362
Location: Germany
Hey lwsandl,

please do a "select * software". Browse throught the result and post here two line, that seemed similar.

Like this:

1111,95F43D5C-BB68-1224-91A1-D0DC325B4FB8,Adobe Acrobat 5.0,5.1,C:\Programme\Adobe\Acrobat 5.0, ... ,20060817150006,20060806201547
2222,95F43D5C-BB68-1224-91A1-D0DC325B4FB8,Adobe Acrobat 5.0,5.1,C:\Programme\Adobe\Acrobat 5.0, ... ,20060817150006,20060806201547

Please provide the data in csv-format.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 11:14 pm 
Offline
Helper

Joined: Fri Jan 13, 2006 8:40 am
Posts: 66
Location: New Jersey
"1435","2E3FC514-F247-BF31-81E0-ED6393DA288D","3D Live Pool",,"C:Program Files3D Live Pool","""C:Program Files3D Live Poolunins000.exe""",,"Etiumsoft, Inc.",,,"http://www.etiumsoft.com",,"96","20060824064639","20060822105231"
"6539","2E3FC514-F247-BF31-81E0-ED6393DA288D","3D Live Pool",,"C:Program Files3D Live Pool","""C:Program Files3D Live Poolunins000.exe""",,"Etiumsoft, Inc.",,,"http://www.etiumsoft.com",,"96","20060824064639","20060823063904"
"30502","2E3FC514-F247-BF31-81E0-ED6393DA288D","3D Live Pool",,"C:Program Files3D Live Pool","""C:Program Files3D Live Poolunins000.exe""",,"Etiumsoft, Inc.",,,"http://www.etiumsoft.com",,"96","20060824064639","20060824064639"

_________________
Windows Server 2003, Apache 2.0.59, PHP 5.14, MySQL 5.0.22


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 11:16 pm 
Offline
Helper

Joined: Fri Jan 13, 2006 8:40 am
Posts: 66
Location: New Jersey
IP Hostname OS Date Audited System Type

128.000.081.124 USPCPARSON XP Pro 2006-08-24
128.000.081.124 USPCPARSON XP Pro 2006-08-24
128.000.081.124 USPCPARSON XP Pro 2006-08-24

_________________
Windows Server 2003, Apache 2.0.59, PHP 5.14, MySQL 5.0.22


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 11:43 pm 
Offline
Moderator

Joined: Sun Aug 06, 2006 1:13 am
Posts: 362
Location: Germany
This is related to audit.vbs. How does audit.vbs writes Software? Why audit.vbs updated all old entrys of this software?


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 24, 2006 11:55 pm 
Offline
Moderator

Joined: Sun Aug 06, 2006 1:13 am
Posts: 362
Location: Germany
Please look at http ://www.open-audit.org/phpbb2/viewtopic.php?t=1302&highlight=


We are talking about the same problem in two threads.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 25, 2006 12:28 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
matze wrote:
This is related to audit.vbs. How does audit.vbs writes Software? Why audit.vbs updated all old entrys of this software?


This is what I would like to know....

I thought it would add an entry to the software table only if the entry did not previously exist, or had changed.

However I think what happens is that the script posts the data regardless of whether there are changes or not.. Mark?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 25, 2006 12:37 am 
I wish I could lock this thread...

Let's move ALL new comments to this thread (same as matze's link above): [url]http: //www.open-audit.org/phpbb2/viewtopic.php?t=1302[/url]

That means stop using this one :)


Top
  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 16 posts ]  Go to page 1, 2  Next

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

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