Open-AudIT
https://www.open-audit.org/phpBB3/

Software register, list users
https://www.open-audit.org/phpBB3/viewtopic.php?f=10&t=4460		 Page 1 of 1
Author:  zeezam [ Thu Mar 03, 2011 5:48 pm ]
Post subject:  Software register, list users
In Software Register audit now lists computers.
Is it possible to list users?
Author:  jpa [ Fri Mar 04, 2011 9:46 am ]
Post subject:  Re: Software register, list users
I'm guessing you want something like this:

Patch software_register_details.php
[code]
Index: software_register_details.php
===================================================================
--- software_register_details.php (revision 1251)
+++ software_register_details.php (working copy)
@@ -36,7 +36,7 @@
$sql2 = "SELECT sum(license_purchase_number) as number_purchased FROM ";
$sql2 .= "software_licenses, software_register WHERE ";
$sql2 .= "license_software_id = software_reg_id AND ";
- $sql2 .= "software_title = '" . $myrow['software_title'] . "'";
+ $sql2 .= "software_title = '" . mysql_real_escape_string($myrow['software_title']) . "'";
$result2 = mysql_query($sql2, $db);
$myrow2 = mysql_fetch_array($result2);

@@ -112,7 +112,7 @@
} else {}

$bgcolor = "#F1F1F1";
-$sql = "select sys.system_uuid, sys.system_os_name, sys.system_description, sys.net_ip_address, sys.system_name, sw.software_name from ";
+$sql = "select sys.system_uuid, sys.system_os_name, sys.system_description, sys.net_ip_address, sys.system_name, sw.software_name, sys.net_user_name from ";
$sql .= "software sw, system sys where ";
$sql .= "sw.software_name = '" . addslashes($name) . "' AND ";
$sql .= "sw.software_uuid = sys.system_uuid AND ";
@@ -123,12 +123,13 @@
if ($myrow = mysql_fetch_array($result)){
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n";
echo "<tr><td class=\"contenthead\" colspan=\"3\"><br />Systems with \"" . $name . "\" installed.</td></tr>\n";
- echo "<tr><td>&nbsp;&nbsp;<b>IP Address</b></td><td>&nbsp;&nbsp;<b>Name</b></td><td>&nbsp;&nbsp;<b>Description</b></td></tr>\n";
+ echo "<tr><td>&nbsp;&nbsp;<b>IP Address</b></td><td>&nbsp;&nbsp;<b>Name</b></td><td>&nbsp;&nbsp;<b>Description</b></td><td>&nbsp;&nbsp;<b>Current User</b></td></tr>\n";
do {
echo "<tr bgcolor=\"" . $bgcolor . "\">\n";
- echo " <td width=\"33%\">&nbsp;&nbsp;" . $myrow["net_ip_address"] . "&nbsp;&nbsp;</td>\n";
- echo " <td width=\"33%\">&nbsp;&nbsp;<a href=\"system.php?pc=" . $myrow["system_uuid"] . "&amp;view=summary\" class=\"content\">" . $myrow["system_name"] . "</a>&nbsp;&nbsp;</td>\n";
- echo " <td width=\"33%\">&nbsp;&nbsp;" . $myrow["system_description"] . "</td>\n";
+ echo " <td width=\"20%\">&nbsp;&nbsp;" . $myrow["net_ip_address"] . "&nbsp;&nbsp;</td>\n";
+ echo " <td width=\"25%\">&nbsp;&nbsp;<a href=\"system.php?pc=" . $myrow["system_uuid"] . "&amp;view=summary\" class=\"content\">" . $myrow["system_name"] . "</a>&nbsp;&nbsp;</td>\n";
+ echo " <td width=\"30%\">&nbsp;&nbsp;" . $myrow["system_description"] . "</td>\n";
+ echo " <td width=\"25%\">&nbsp;&nbsp;" . $myrow["net_user_name"] . "</td>\n";
echo "</tr>\n";

if ($bgcolor == "#F1F1F1") { $bgcolor = "#FFFFFF"; } else { $bgcolor = "#F1F1F1"; }
[/code]

Or replace it with the following file after removing the .txt extension.

Attachments:
software_register_details.php.txt [7.41 KiB]
Downloaded 421 times
Author:  zeezam [ Wed Mar 09, 2011 1:14 am ]
Post subject:  Re: Software register, list users
How do I use that one?
Author:  jpa [ Wed Mar 09, 2011 3:09 am ]
Post subject:  Re: Software register, list users
Download the attached "software_register_details.php.txt" file
Remove the .txt extension
Overwrite the existing software_register_details.php file in your web directory with the downloaded one

Go to your OpenAudit site
Select "Software Register" from the menu then the "Software Register" submenu
Click on a software package name
See that I've added a current user to the Systems with <software> installed

Then realize that I might have misunderstood you completely and you want to audit software that is installed per-user and not per-computer. I am not psychic and your original request is pretty terse. You'll need to give more detail in your request if you want something different.
Author:  zeezam [ Wed Mar 09, 2011 7:51 pm ]
Post subject:  Re: Software register, list users
Worked like a charm :)

Is it possible to see in audit when a software was last used by the user?
Author:  jpa [ Thu Mar 10, 2011 2:51 am ]
Post subject:  Re: Software register, list users
No.

Although most things are possible you'll not get this data without a massive amount of work.
Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/