Open-AudIT

I tried to add a pc and I get the following message:

[code]Verbose:
User:
Verbose: y
System:
UUID:
Timestamp:
Software Audit:

SELECT MAX(system_audits_timestamp) AS timestamp FROM system_audits WHERE system_audits_uuid = ''
INSERT INTO system_audits (system_audits_uuid, system_audits_timestamp, system_audits_username) VALUES ('','','')
INSERT INTO system (system_uuid, system_first_timestamp) VALUES ('','')
UPDATE system SET system_timestamp = '' WHERE system_uuid = ''
Close

Page was generated in 0.07 seconds ![/code]

Is there some simple step that I might have missed somewhere? Everything else seems to work when I run audit.vbs on a standalone system.

_________________
Server Info:
OS : Windows Server 2003
Auditing: ~300 machines
LDAP: Windows Server 2003 Active Directory

Are you pasting the details from audit.vbs into that form? The idea of add pc is to take care of offline audits. If you are on the same network, just let audit.vbs handle adding the computers.

I guess I should re-phrase that...

Running audit.vbs on a system sends data OK to the server, but this query code that I posted comes up after I click the menu option in Open-AudIT to add a PC via the webpage.

No results are ever posted to the server db after clicking 'submit' at the admin_pc_add_2.php page.

Hope that clears my post up a little!

_________________
Server Info:
OS : Windows Server 2003
Auditing: ~300 machines
LDAP: Windows Server 2003 Active Directory

Whoops, didn't mean to double-post ...

_________________
Server Info:
OS : Windows Server 2003
Auditing: ~300 machines
LDAP: Windows Server 2003 Active Directory

So you paste the results of a scan into the add pc form?

[quote="mikeyrb"]So you paste the results of a scan into the add pc form?

_________________
Server Info:
OS : Windows Server 2003
Auditing: ~300 machines
LDAP: Windows Server 2003 Active Directory

Correct. We don't have a way to have the server do the auditing. This form is for adding pc's that aren't on the same network as the server (generally offline computers).

Ah - OK then! Thanks for that clarification.

What was the reason for not being able to perform an audit remotely from the server? The only reason I ask is that I had been running an ASP page that could pull WMI statistics from a remote PC through a web browser, so I know that it can be done...just curious what was the limitation there?

I think I'll need to pick up PHP and start playing...

Rob

_________________
Server Info:
OS : Windows Server 2003
Auditing: ~300 machines
LDAP: Windows Server 2003 Active Directory

The limitation is that the current version can be run on either windows or linux. Linux of course cannot pull wmi data easily, so there you go. It's something to look at for the future, but for now, it's not a priority.

That being said, I wouldn't be against someone creating a web page audit (I suppose running on IIS, but apache would be nice if posible).

[quote="mikeyrb"]That being said, I wouldn't be against someone creating a web page audit (I suppose running on IIS, but apache would be nice if posible).

_________________
Server Info:
OS : Windows Server 2003
Auditing: ~300 machines
LDAP: Windows Server 2003 Active Directory

[quote="qc_metal"][quote="mikeyrb"]That being said, I wouldn't be against someone creating a web page audit (I suppose running on IIS, but apache would be nice if posible).