Open-AudIT

What's on your network?
It is currently Sat Jul 21, 2018 9:40 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 13 posts ] 
Author Message
PostPosted: Thu Feb 08, 2018 8:57 pm 
Offline
Newbie

Joined: Mon Jan 29, 2018 6:55 pm
Posts: 21
Hi.
I added a field for printers marking them for a connection type (IP, USB, COM, etc.). When is set the value this Error message appears:
[img]
Attachment:
2018-02-08%2011_53_05-Open-AudIT.jpg
[/img]

Thats the config of the field:
[img]
Attachment:
2018-02-08%2011_52_45-Open-AudIT.jpg
[/img]


Attachments:
2018-02-08 11_53_05-Open-AudIT.jpg
2018-02-08 11_53_05-Open-AudIT.jpg [ 24.29 KiB | Viewed 1074 times ]
2018-02-08 11_52_45-Open-AudIT.jpg
2018-02-08 11_52_45-Open-AudIT.jpg [ 45.24 KiB | Viewed 1074 times ]
Top
 Profile  
Reply with quote  
PostPosted: Fri Feb 09, 2018 3:04 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
I can't replicate the error. What is the field config for "drucker anschluss"?


Top
 Profile  
Reply with quote  
PostPosted: Mon Feb 12, 2018 5:48 pm 
Offline
Newbie

Joined: Mon Jan 29, 2018 6:55 pm
Posts: 21
Okay, i found out that i can update the field, when i use the pre-defined Group "All Devices" (ID:1). I can't update the field for my Group "Printers" with the following Query:

Code:
SELECT DISTINCT system.id, system.icon, system.name, system.manufacturer, system.model, system.serial, field.value
FROM system LEFT JOIN field ON (system.id = field.system_id)
WHERE @filter AND system.type LIKE '%printer%'
ORDER BY system.name ASC


By the way, how can i get the "Bulk edit"-Button in an Query without the (system.id)-Function?
A Group-Query with "SELECT DISTINCT (system.id)..." retrieves a Bulk Edit Button. A Query with "SELECT DISTINCT system.id, system.name..." shows only checkboxes but without "Bulk Edit"-Button.

Thanks.


Top
 Profile  
Reply with quote  
PostPosted: Tue Feb 13, 2018 2:34 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
Groups don't work this way with recent versions of OpenAudit. Your query should return a simple list of system IDs.


Top
 Profile  
Reply with quote  
PostPosted: Wed Feb 14, 2018 8:14 pm 
Offline
Newbie

Joined: Mon Jan 29, 2018 6:55 pm
Posts: 21
Edited the Group to simple:
Code:
SELECT DISTINCT(system.id) FROM system WHERE @filter AND system.type LIKE '%printer%'


I cant fill out any field for any Device Groups. The same when i add a new field for the Group "All Devices".


Attachments:
2018-02-14 11_15_11-Open-AudIT.jpg
2018-02-14 11_15_11-Open-AudIT.jpg [ 20.69 KiB | Viewed 1038 times ]
Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 15, 2018 2:10 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
Maybe it has something to do with your Orgs config? If the org data is not secret could you PM your Orgs table to me?

Admin->Database->List tables
Click blue details icon for the orgs table
Click Export data to CSV button
PM me the CSV output from the bottom of the page


Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 15, 2018 9:04 pm 
Offline
Newbie

Joined: Mon Jan 29, 2018 6:55 pm
Posts: 21
No, our org_id is not secret.

Code:
"id","name","parent_id","description","ad_group","edited_by","edited_date",
"1","RWG Gnarrenburg eG","1","","open-audit_orgs_default_organisation","Administrator","2018-01-24 22:16:17",


Top
 Profile  
Reply with quote  
PostPosted: Fri Feb 16, 2018 2:33 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
At this point I don't know what is happening. I can't replicate this and I'm not smart enough to figure it out. I can get your symptoms but only by editing the source to break things.


Top
 Profile  
Reply with quote  
PostPosted: Wed Feb 21, 2018 12:42 am 
Offline
Newbie

Joined: Mon Jan 29, 2018 6:55 pm
Posts: 21
In Bulk Edit Mode i see duplicate option-entries for type and class fields. In my database are not duplicates. Why?!?!

Okay i will perform a new clean Installation on an new WinServ2008 R2 VM. After that i restore my system tables.


Attachments:
2018-02-20 15_41_33-mRemoteNG - rwggnb.xml - G20585OPENAUDIT.jpg
2018-02-20 15_41_33-mRemoteNG - rwggnb.xml - G20585OPENAUDIT.jpg [ 61.22 KiB | Viewed 972 times ]
2018-02-20 15_40_20-Open-AudIT.jpg
2018-02-20 15_40_20-Open-AudIT.jpg [ 35.47 KiB | Viewed 973 times ]
Top
 Profile  
Reply with quote  
PostPosted: Wed Feb 21, 2018 1:11 am 
Offline
Newbie

Joined: Mon Jan 29, 2018 6:55 pm
Posts: 21
Okay, i removed OpenAudIT clean after i backupped the most importand tables. After a clean installation (new installer from www.open-audit.org), i restored the following tables in that order: configuration, orgs, locations, networks, credentials and discoveries. I started a simple one-device-discovery. Now i can create own Fields. The only thing i can't understand is that there are duplicate options in type and class when i open bulk edit mode. Editing only one system there are no duplicates. Even there are no duplicate's in Database.... Why?


Top
 Profile  
Reply with quote  
PostPosted: Wed Feb 21, 2018 4:14 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
Yes, I see the duplicate attributes as well. I can see where it happens and will try to get it fixed.


Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 22, 2018 6:09 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1956
Location: Brisbane, Australia
Duplicate attributes fixed for 2.1.1 (just released).

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Mon Mar 05, 2018 8:35 pm 
Offline
Newbie

Joined: Mon Jan 29, 2018 6:55 pm
Posts: 21
There are duplicate entries in Manage > Devices > Create Device > Manual Input too.
Fix needed.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 

All times are UTC + 10 hours


Who is online

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