1 of 1 people found this helpful
if you create a own report you can create a new query in it with checks for [User Provided Value].
Some hints you can find here:
- How to add a "total count" box in a custom report
I am guessing you are trying to do some sort of organizational reporting based on the three characters? Get departmental (or site or whatever) based reports. Managed Planet's Executive Report Pack makes this really easy to do heirarchical organizational based reporting.
I don't think there is a way to do this without a third-party add-on. Closest you could get is to create twenty queries using LIKE ABC as the criteria and saving them. Assign each the same custom column set and it is easy to right-click and run as a report. You'll have to do it for each one but twenty isn't as bad as it could have been.
Alternatively you simply take your list of machines, add your cutom columns and then create a .csv report. When you have this, import it into Excell and use the function LEFT(A2,3) where A2 is the cell containing the device name, and the ,3 is the number of characters to copy from the beginning of the device name. You could then use this to do your grouping.
Mark Star - MarXtar LANDesk Enhancements
Home of Power State Notifier & Wake-On-WAN for LANDesk
it would be so helpful, if we could use "count" and other SQL stuff in both consoles, web AND native console. ...
Try "Computer"."Device Name" LIKE "123%" and you will get a listing of all systems with the prefix in the computer name.
Thanks, but that would only give me the PC's with the prefix of "123". I needed a report of ALL PCs in my environment, grouped by PC Prefix.
I was able to accomplish this with some VBS and then later read the registry entry on a scan (ldappl3.ini)
strRoot = "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ComputerName\ActiveComputerName\ComputerName"
strModify = objShell.RegRead(strRoot)
If Not IsEmpty(strModify) then
strRoot = "HKEY_LOCAL_MACHINE\Software\AGENCY\LANDesk\PCPrefix"
strModify = (Left(strModify,3))
strModify = objShell.RegWrite(strRoot ,strModify, "REG_SZ")
I would venture to guess that if you exported a query out to a csv file, and then manipulated it in Excel it would be much easier.
what's not easy about "Computer"."Device Name" LIKE [0-9][0-9][0-9]*
edit: oh, didn't see that grouping is desired. That is easier to do with an external tool... it can be done with the report engine, but it's not as easy as Excel.