Tech Tips, Asset & CMDB
Confusing Patch Bulletin
Why do I see the same installer listed 3 times when I created the Software Update Tasks for MS08-053? See the graphic below.
How to Include Non-Executable Files in Inventory Scans
Need to get files other than the standard .exe files into your inventories. Perhaps the programs you need to inventory do not have .exe files such as ActiveX Controls.
- 5 comments
- Read more
- 688 reads
Show Computers by Location with Asset
Great view to have in your Asset database for reporting the locations your PCs are at. With this view you can easily add a Location column with address to any report you have.
Easily Add a Primary User Column to Your Reports
It is nice to be able to see who the primary user is in a report. Since the Primary User table is based on a given month you have to add that as a parameter to every report you want to see Primary User on.
SQL Report: Windows Service Pack Level by OS
One of the problems with the canned compliance reports is the lack of easily isolated Service Pack information, so I created a report that allows you to select Windows 2000, XP, or Vista and then filter out the most recent SP for that OS.
SQL Report: Computers with MS Office 2003 Without 2007 Compatibility Pack
Here's some SQL that'll query computers with MS Office 2003 without the Office 2007 compatibility pack. Just go to reports, create a new one, and select 'Enter SQL Directly', then copy and paste the sql into there.
- 2 comments
- Read more
- 722 reads
License Reclamation in Barcode 6.6
One of the toughest parts of Barcode is understanding how licenses can be freed up for scanners no longer in use.
My Hardware Inventory Says "Task Stopped" Why?
Recently, it was discovered that a client machine had a Task History entry for Hardware Inventory, AEXMACHINV.exe of 'Task Stopped'? In fact, AEXMACHINV.exe stays active and in place, showing up in the computers task manager until a time-out occurs. Of course, there was no hardware inventory on the server either. What happened?
Report a Purchase Order's Assets and Their Locations
Want a report of the assets on a purchase order along with the owner and location? Give this a try.
Setting the Default Collection in a Collection Picker
Last time we covered adding a collection picker to your reports. In case you missed it you can find it here. I know after reading the prior tip you were excited beyond belief, and happily adding collection pickers to all your reports.















Recent comments
37 min 57 sec ago
1 hour 12 min ago
1 hour 59 min ago
3 hours 12 min ago
3 hours 19 min ago
3 hours 31 min ago
3 hours 43 min ago
4 hours 1 min ago
4 hours 16 min ago
4 hours 23 min ago