Snipe-IT Departmental Reporting

Obsolesce

@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?

@DustinB3403 @Obsolesce

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.

wirestyle22

@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?

@DustinB3403 @Obsolesce

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.

wirestyle22

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.

black3dynamite

@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.

https://snipe-it.readme.io/docs/ldap-sync

wirestyle22

Still timing out even with a gig of memory allocated to php. Unsure how to sync all of AD. There is about 6k users.

notverypunny

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

wirestyle22

This post is deleted!

wirestyle22

@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.

notverypunny

@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?

wirestyle22

@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

black3dynamite

Here’s something from Moodle forum
https://moodle.org/mod/forum/discuss.php?d=49336

wirestyle22

@black3dynamite said in Snipe-IT Departmental Reporting:

Here’s something from Moodle forum
https://moodle.org/mod/forum/discuss.php?d=49336

Involved for something so simple

wirestyle22

Trying to sync each individual OU and then seeing if I can sync just the changes made after that. Hopefully makes it manageable.

wirestyle22

@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

wirestyle22

Got it to work. Edit the below file.

app/Console/Commands/LdapSync.php

Edit max_execution time and memory_limit

ini_set('max_execution_time', 1200); //600 seconds = 10 minutes

ini_set('memory_limit', '1000M');

Dashrender

@wirestyle22 said in Snipe-IT Departmental Reporting:

Got it to work. Edit the below file.

app/Console/Commands/LdapSync.php

Edit max_execution time and memory_limit
ini_set('max_execution_time', 1200); //600 seconds = 10 minutes 
ini_set('memory_limit', '1000M');

what was the default in those?

wirestyle22

@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.php

Edit max_execution time and memory_limit
ini_set('max_execution_time', 1200); //600 seconds = 10 minutes 
ini_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');

Dashrender

@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.php

Edit max_execution time and memory_limit
ini_set('max_execution_time', 1200); //600 seconds = 10 minutes 
ini_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.

wirestyle22

@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.php

Edit max_execution time and memory_limit
ini_set('max_execution_time', 1200); //600 seconds = 10 minutes 
ini_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.