June 2011 - Posts

Checking Your Boundaries From IE

This article, that was published today on Microsoft’s Manageability blog, got me thinking:-

http://blogs.technet.com/b/manageabilityguys/archive/2011/06/30/testing-slp-availability.aspx

You may have seen in one of my previous articles, that you can create your own search providers in Internet Explorer, by going to http://www.ieaddons.com/createsearch.aspx (see my previous article for an explanation).

So, I thought I’d create a couple of quick searches:-

Sccm AD Site Boundary Checker - http://<my slp>/sms_slp/slp.dll?site&ad=TEST
Sccm Subnet Boundary Checker - http://<my slp>/sms_slp/slp.dll?site&ip=TEST

An example of running this is shown :-

ieBoundChk

Posted by Tom_Watson | with no comments
Filed under: ,

Software Metering Suites And Their Individual Applications

One feature of Software Metering is having the ability to meter multiple applications as one “suite” of applications.  The method Microsoft suggests it to give multiple rules the same name.  E.g. for Office 2007:-

Software Metering Rule Name File Name Original File Name Version
Microsoft Office 2007 MSACCESS.EXE MSACCESS.EXE 12.*
Microsoft Office 2007 EXCEL.EXE EXCEL.EXE 12.*
Microsoft Office 2007 INFOPATH.EXE INFOPATH.EXE 12.*
Microsoft Office 2007 OUTLOOK.EXE OUTLOOK.EXE 12.*
Microsoft Office 2007 POWERPNT.EXE POWERPNT.EXE 12.*
Microsoft Office 2007 MSPUB.EXE MSPUB.EXE 12.*
Microsoft Office 2007 WINWORD.EXE WINWORD.EXE 12.*

So basically what this does is if you run one of the Software Metering reports that looks for a rule name, and you select “Microsoft Office 2007”, it will match instances where any of those files have been ran.  Now that may be fine if you wanted to meter suites.  But what if someone wants a report on one of those individual applications (e.g. Outlook)?

The workaround is to change the rule names like the example below shows:-

Software Metering Rule Name File Name Original File Name Version
Microsoft Office Access 2007 MSACCESS.EXE MSACCESS.EXE 12.*
Microsoft Office Excel 2007 EXCEL.EXE EXCEL.EXE 12.*
Microsoft Office InfoPath 2007 INFOPATH.EXE INFOPATH.EXE 12.*
Microsoft Office Outlook 2007 OUTLOOK.EXE OUTLOOK.EXE 12.*
Microsoft Office PowerPoint 2007 POWERPNT.EXE POWERPNT.EXE 12.*
Microsoft Office Publisher 2007 MSPUB.EXE MSPUB.EXE 12.*
Microsoft Office Word 2007 WINWORD.EXE WINWORD.EXE 12.*

Now on face value, you may think this has removed the ability to run a report for a “suite”.  However, if you make a slight change to your metering reports, in the criteria sections (i.e. WHERE xxx…), you will have the ability to monitor a “suite” again, by picking a wildcard for your suite.

e.g. change the WHERE clause in the "Computers that have run a specific metered software program" :-

Replace

where mf.ProductName = @RuleName

with

where mf.ProductName LIKE @RuleName

As you can see this would change the report to allow wildcards.  So in our example, if you wanted to find systems that have ran anything from the Microsoft Office 2007 “suite” you would use the following criteria :-

Microsoft Office%2007

Replacing “=” with “LIKE” in the WHERE clause, lets you use wildcards.  “%” is the most common SQL wildcard, which simply means match anything.

The simple reason this works is that the clients have no idea of rule names.  They simply know rules by their ID, and criteria (filename and version).  The rule name is simply a human readable tag for the rule to be used when running reports.

Posted by Tom_Watson | with no comments
Filed under: , ,

System Warranty Report

I had this report posted on the myITforum forums before, but it’s been a little while since I updated it.  Until now.  Basically this takes the serial number from common desktop/laptop vendors, and provide URLs to allow you to lookup the warranty information on those vendors’ websites.

SELECT DISTINCT
       cs.Name0 AS "Computer Name",
       enc.SerialNumber0,
       enc.SMBIOSAssetTag0,
       bios.SerialNumber0 AS "PC Bios Serial Number",
       bios.ReleaseDate0 AS "PC Bios Release Date",
       cs.Manufacturer0,
       cs.Model0,
       "Estimated Date of CPU Manufacture" =
         CASE
           WHEN (CAST(cpu.CPU_Birth AS VARCHAR) IS NULL) THEN '(Not Available)'
           ELSE  CAST(cpu.CPU_Birth AS VARCHAR)
         END,
       pr.IsMulticore0 AS "Is Multi Processor System",
       CASE
         WHEN cs.Manufacturer0 LIKE 'Hewlett%' THEN '
http://h20000.www2.hp.com/bizsupport/TechSupport/WarrantyResults.jsp?sn=' + enc.serialnumber0 + '&country=US'
         WHEN cs.Manufacturer0 LIKE 'HP%' THEN '
http://h20000.www2.hp.com/bizsupport/TechSupport/WarrantyResults.jsp?sn=' + enc.SerialNumber0 + '&country=US'
         WHEN cs.Manufacturer0 LIKE 'Compaq%' THEN '
http://h20000.www2.hp.com/bizsupport/TechSupport/WarrantyResults.jsp?sn=' + enc.SerialNumber0 + '&country=US'
         WHEN cs.Manufacturer0 LIKE 'Dell%' THEN '
http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?servicetag=' + enc.SerialNumber0
         WHEN cs.Manufacturer0 LIKE 'IBM%' THEN '
http://www-307.ibm.com/pc/support/site.wss/warrantyLookup.do?type=' + LEFT (cs.model0, 4) + '&serial=' + bios.SerialNumber0 + '&country=897'
         WHEN cs.Manufacturer0 LIKE 'Lenovo%' THEN '
http://www-307.ibm.com/pc/support/site.wss/warrantyLookup.do?type=' + LEFT (cs.model0, 4) + '&serial=' + bios.SerialNumber0 + '&country=897'
         WHEN cs.Manufacturer0 LIKE 'Acer%' THEN '
http://secure3.tx.acer.com/FindSystem/findsystem.aspx?Title=Information&sn=' + bios.SerialNumber0
         ELSE '(Not available)'
       END AS "Warranty Information"
FROM   dbo.v_GS_PROCESSOR pr
JOIN   dbo.v_GS_SYSTEM_ENCLOSURE enc
  ON   enc.ResourceID = pr.ResourceID
JOIN   dbo.v_GS_PC_BIOS bios
  ON   bios.ResourceID = pr.ResourceID
JOIN   dbo.v_GS_COMPUTER_SYSTEM cs
  ON   cs.ResourceID = pr.ResourceID
LEFT JOIN dbo.v_LU_CPU cpu
  ON   Lower(cpu.CPUHash) = Lower(pr.CPUHash0)
WHERE  cs.Name0 = @Name
  AND  enc.ChassisTypes0 <> 12

As you can see, it lists warranty URLs for HP/Compaq, Dell, IBM/Lenovo, and Acer.  I couldn’t find URLs for other vendors, but if anyone does know of any of these, let me know.

Posted by Tom_Watson | with no comments
Filed under: , ,