Get a list of all Assets based upon location hierarchy
If you are using Asset, you most likely have locations setup in a hierarchy. Building #1 has 3 floors, each floor has 3 sections, each section has two areas, etc. How can you find out easily how many assets are located in any part, or all of that building based upon location? If you were going through a hardware refresh and needed to know how many Dell Optiplex 745 desktops were still in a building, could you find the answer? Could you break that answer down by locations within that location?
This SQL will answer that question and many more very quickly. Using SQL that was posted under another download (recursive location search) as a base, we will expand upon that and allow it to do something really useful for us. The attached SQL will allow you to filter by Asset Type, Manufacturer and Model number from any point within the location hierarchy, but you can easily expand this to search for anything.
The data displayed in Organization View and Groups is a starting point, but it isn't very friendly for doing in-depth analysis of data.