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 4:27 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: MDAC/WDAC version
PostPosted: Sat Jan 19, 2008 10:45 pm 
Offline
Open-AudIT Fellow

Joined: Thu May 17, 2007 5:47 pm
Posts: 568
Location: Italy
MDAC/WDAC isn't currently listed among softwares detected on MS boxes. To include them, please add the following lines to audit.vbs, just after the end of the "Installed Codecs" section:
[code]
comment = "MDAC/WDAC, DirectX, Media Player, IE and OE Versions"
if verbose = "y" then
wscript.echo comment
end if

' Add MDAC/WDAC to the Software Register
strKeyPath = "SOFTWARE\Microsoft\DataAccess"
strValueName = "Version"
oReg.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,dac_version
if SystemBuildNumber <> "6000" then
display_name = "MDAC"
else
display_name = "Windows DAC"
end if
form_input = "software^^^" & display_name & "^^^" _
& dac_version & "^^^" _
& "" & "^^^" _
& "" & "^^^" _
& OSInstall & "^^^" _
& "Microsoft Corporation^^^" _
& "" & "^^^" _
& "" & "^^^" _
& "http://msdn2.microsoft.com/en-us/data/default.aspx" & "^^^ "
entry form_input,comment,objTextFile,oAdd,oComment
form_input = ""


[/code]
Then, to include also MSXML, .Net Framework and MDAC/WDAC to the OS settings - Software system viewdef and change layout to horizontal, replace as follows the "software" section in system_viewdef_os.php
[code]
"software"=>array(
"headline"=>__("Software"),
"sql"=>"SELECT software_name, software_version
FROM software, system
WHERE system_uuid = '".$_REQUEST["pc"]."' AND software_uuid = system_uuid AND software_timestamp = system_timestamp
AND (software_name LIKE 'Internet Explorer%' OR software_name LIKE 'DirectX%' OR software_name = 'Windows Media Player'
OR software_name LIKE 'MSXML%' OR software_name LIKE 'Microsoft .NET Framework%' OR software_name = 'MDAC'
OR software_name = 'Windows DAC')
AND software_name NOT LIKE '%Language Pack%' AND software_name NOT LIKE '%hotfix%'
ORDER BY software_name ",
"table_layout"=>"horizontal",
"image"=>"images/software_l.png",
"fields"=>array("10"=>array("name"=>"software_name", "head"=>__("Name"),),
"20"=>array("name"=>"software_version", "head"=>__("Version"),),
),
),
[/code]
Finally, to modify accordingly the Full PDF report also, change as follows the "system_software" section in system_viewdef_report_full.php
[code]
"system_software"=>array(
"headline"=>__("System Software"),
"sql"=>"SELECT software_name, software_version
FROM software, system
WHERE system_uuid = '".$pc."' AND software_uuid = system_uuid AND software_timestamp = system_timestamp
AND (software_name LIKE 'Internet Explorer%' OR software_name LIKE 'DirectX%' OR software_name = 'Windows Media Player'
OR software_name LIKE 'MSXML%' OR software_name LIKE 'Microsoft .NET Framework%' OR software_name = 'MDAC'
OR software_name = 'Windows DAC')
AND software_name NOT LIKE '%Language Pack%' AND software_name NOT LIKE '%hotfix%'
ORDER BY software_name ",
"table_layout"=>"horizontal",
"fields"=>array("10"=>array("name"=>"software_name", "head"=>__("Name"),),
"20"=>array("name"=>"software_version", "head"=>__("Version"),),
),
),
[/code]
Please, let me know if it's OK, particularly on Vista (not tested) where it should show Windows DAC instead of MDAC. Thanks

_________________
Edoardo


Top
 Profile  
Reply with quote  
 Post subject: Re: MDAC/WDAC version
PostPosted: Wed Jan 30, 2008 10:14 pm 
Offline
Open-AudIT Fellow

Joined: Thu May 17, 2007 5:47 pm
Posts: 568
Location: Italy
Added at SVN rev. 959.

_________________
Edoardo


Top
 Profile  
Reply with quote  
 Post subject: Re: MDAC/WDAC version
PostPosted: Wed Jan 30, 2008 10:47 pm 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
Looks very good... :lol: Just updated and ran an audit. No problems so far... 8)

_________________
Andrew

[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory[/size]


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.  [ 3 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