Cant Do a Global Search of Fields in Snipe IT

[jayavman]

I wish Snipe IT Did a Global Search of Asset Changes of all assets (Eg. serial numbers/Custom Fields/ ) but they have advised its too much strain on the DB system. (even know this script i wrote fly's)

Pretty Much in the search field you can put any search comment and it will search the db for that and give you a reference to the Item ID. You can then click on the item ID and it will show you the page that has found comments relating to it

Create a search.php file and put this in, (change the bolded things with your info)
searchscript.txt

Maybe handy for people who need to know the history of things that have moved between asset ids.

[snipe]

If you had 5 million+ rows of action logs, I doubt very much that it would fly. (Also searching the activity report already does this.)