Tech Tips, Asset & CMDB

Confusing Patch Bulletin

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.

3.95238
Average: 4 (21 votes)
How to Include Non-Executable Files in Inventory Scans

How to Include Non-Executable Files in Inventory Scans

robertser's picture

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.

3.57143
Average: 3.6 (21 votes)
Show Computers by Location with Asset

Show Computers by Location with Asset

robertser's picture

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.

4.05
Average: 4.1 (20 votes)
Easily Add a Primary User Column to Your Reports

Easily Add a Primary User Column to Your Reports

robertser's picture

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.

4.26087
Average: 4.3 (23 votes)
SQL Report: Windows Service Pack Level by OS

SQL Report: Windows Service Pack Level by OS

MFINN's picture

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.

3.875
Average: 3.9 (24 votes)
SQL Report: Computers with MS Office 2003 Without 2007 Compatibility Pack

SQL Report: Computers with MS Office 2003 Without 2007 Compatibility Pack

MFINN's picture

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.

3.894735
Average: 3.9 (38 votes)
License Reclamation in Barcode 6.6

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.

3.26923
Average: 3.3 (26 votes)
My Hardware Inventory Says

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?

3.56
Average: 3.6 (25 votes)
Report a Purchase Order's Assets and Their Locations

Report a Purchase Order's Assets and Their Locations

sfletcher's picture

Want a report of the assets on a purchase order along with the owner and location? Give this a try.

3.857145
Average: 3.9 (21 votes)
Setting the Default Collection in a Collection Picker

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.

3.90909
Average: 3.9 (22 votes)
Syndicate content