Snipe-IT Departmental Reporting
-
I am trying to run reports that are based on the enterprise (multiple companies was a successful report), company specific (successful) and departmental (not successful). It seems that Snipe-IT cannot assign assets to departments, only users/locations/assets, so that means that in order for me to run reports on a per department basis I need to have every single AD account not only added to snipe-it but the department added to the account as well as updated in real time when new accounts are created. Is there a way around this?
-
@wirestyle22 said in Snipe-IT Departmental Reporting:
I am trying to run reports that are based on the enterprise (multiple companies was a successful report), company specific (successful) and departmental (not successful). It seems that Snipe-IT cannot assign assets to departments, only users, so that means that in order for me to run reports on a per department basis I need to have every single AD account not only added to snipe-it but also updated in real time when new accounts are created. Is there a way around this?
You don't have it connected to AD? When I did that, it had all AD users in it, any AD user could sign in successfully according to group permissions.
I haven't done much with reporting in Snipe-IT though, I mainly used it for software keys, assignments, and tracking.
-
@Obsolesce said in Snipe-IT Departmental Reporting:
@wirestyle22 said in Snipe-IT Departmental Reporting:
I am trying to run reports that are based on the enterprise (multiple companies was a successful report), company specific (successful) and departmental (not successful). It seems that Snipe-IT cannot assign assets to departments, only users, so that means that in order for me to run reports on a per department basis I need to have every single AD account not only added to snipe-it but also updated in real time when new accounts are created. Is there a way around this?
You don't have it connected to AD? When I did that, it had all AD users in it, any AD user could sign in successfully according to group permissions.
I haven't done much with reporting in Snipe-IT though, I mainly used it for software keys, assignments, and tracking.
LDAP is configured. Only when a user signs in is the account created though. I need to add all AD accounts without them having to log in. I'd think I would need to sync in real time as well. Unsure how you guys are managing this part of it if at all.
-
LDAP User Sync is timing out. I will need to fix that and automate the process via a script I think. Probably need to give php more memory or make the scope smaller.
-
@wirestyle22 said in Snipe-IT Departmental Reporting:
LDAP User Sync is timing out. I will need to fix that and automate the process via a script I think. Probably need to give php more memory or make the scope smaller.
-
Still timing out even with a gig of memory allocated to php. Unsure how to sync all of AD. There is about 6k users.
-
I can't remember what the fix is, but I seem to recall there being a default limit of 500 or 1k on LDAP query results.
....
here it is
http://www.microsoftnow.com/2008/10/increasing-number-of-objects-returned.html
-
This post is deleted! -
@notverypunny said in Snipe-IT Departmental Reporting:
I can't remember what the fix is, but I seem to recall there being a default limit of 500 or 1k on LDAP query results.
....
here it is
http://www.microsoftnow.com/2008/10/increasing-number-of-objects-returned.html
Even with that change it still timed out. I allocated 1024 memory to the php memory_limit as well.
-
@wirestyle22 said in Snipe-IT Departmental Reporting:
@notverypunny said in Snipe-IT Departmental Reporting:
I can't remember what the fix is, but I seem to recall there being a default limit of 500 or 1k on LDAP query results.
....
here it is
http://www.microsoftnow.com/2008/10/increasing-number-of-objects-returned.html
Even with that change it still timed out. I allocated 1024 memory to the php memory_limit as well.
damn... maybe try running the query (or an equivalent) via cli just to validate that it's not a problem with the underlying client-server connection? Do the docs make any mention of tweaking the php timeouts?
-
@notverypunny said in Snipe-IT Departmental Reporting:
@wirestyle22 said in Snipe-IT Departmental Reporting:
@notverypunny said in Snipe-IT Departmental Reporting:
I can't remember what the fix is, but I seem to recall there being a default limit of 500 or 1k on LDAP query results.
....
here it is
http://www.microsoftnow.com/2008/10/increasing-number-of-objects-returned.html
Even with that change it still timed out. I allocated 1024 memory to the php memory_limit as well.
damn... maybe try running the query (or an equivalent) via cli just to validate that it's not a problem with the underlying client-server connection? Do the docs make any mention of tweaking the php timeouts?
Documentation looks old. it doesn't use artisan anymore. Not sure how to run it from the cli as a result
-
Here’s something from Moodle forum
https://moodle.org/mod/forum/discuss.php?d=49336 -
@black3dynamite said in Snipe-IT Departmental Reporting:
Here’s something from Moodle forum
https://moodle.org/mod/forum/discuss.php?d=49336Involved for something so simple
-
Trying to sync each individual OU and then seeing if I can sync just the changes made after that. Hopefully makes it manageable.
-
@wirestyle22 said in Snipe-IT Departmental Reporting:
Trying to sync each individual OU and then seeing if I can sync just the changes made after that. Hopefully makes it manageable.
Didn't work. Sigh
-
Got it to work. Edit the below file.
app/Console/Commands/LdapSync.phpEdit
max_executiontime andmemory_limitini_set('max_execution_time', 1200); //600 seconds = 10 minutesini_set('memory_limit', '1000M'); -
@wirestyle22 said in Snipe-IT Departmental Reporting:
Got it to work. Edit the below file.
app/Console/Commands/LdapSync.phpEdit
max_executiontime andmemory_limitini_set('max_execution_time', 1200); //600 seconds = 10 minutesini_set('memory_limit', '1000M');what was the default in those?
-
@Dashrender said in Snipe-IT Departmental Reporting:
@wirestyle22 said in Snipe-IT Departmental Reporting:
Got it to work. Edit the below file.
app/Console/Commands/LdapSync.phpEdit
max_executiontime andmemory_limitini_set('max_execution_time', 1200); //600 seconds = 10 minutesini_set('memory_limit', '1000M');what was the default in those?
ini_set('max_execution_time', 600); //600 seconds = 10 minutes
ini_set('memory_limit', '500M'); -
@wirestyle22 said in Snipe-IT Departmental Reporting:
@Dashrender said in Snipe-IT Departmental Reporting:
@wirestyle22 said in Snipe-IT Departmental Reporting:
Got it to work. Edit the below file.
app/Console/Commands/LdapSync.phpEdit
max_executiontime andmemory_limitini_set('max_execution_time', 1200); //600 seconds = 10 minutesini_set('memory_limit', '1000M');what was the default in those?
ini_set('max_execution_time', 600); //600 seconds = 10 minutes
ini_set('memory_limit', '500M');Wow - so it took more than 10 or more than 500 M RAM to import all that - due to your numbers, I 'm guessing it was the RAM more than the time.
-
@Dashrender said in Snipe-IT Departmental Reporting:
@wirestyle22 said in Snipe-IT Departmental Reporting:
@Dashrender said in Snipe-IT Departmental Reporting:
@wirestyle22 said in Snipe-IT Departmental Reporting:
Got it to work. Edit the below file.
app/Console/Commands/LdapSync.phpEdit
max_executiontime andmemory_limitini_set('max_execution_time', 1200); //600 seconds = 10 minutesini_set('memory_limit', '1000M');what was the default in those?
ini_set('max_execution_time', 600); //600 seconds = 10 minutes
ini_set('memory_limit', '500M');Wow - so it took more than 10 or more than 500 M RAM to import all that - due to your numbers, I 'm guessing it was the RAM more than the time.
Not sure honestly--it took awhile. I spoke to a snipe-it Dev and they could sync 15k accounts with these settings. I needed this functionality so I can create a script to sync users every day at 1:00 AM.
