BMC Client Management Community Blog

Last Reboot – Free Query (Using Dynamic Date)

Posted by on Dec 18, 2017 in FPAC | Comments Off on Last Reboot – Free Query (Using Dynamic Date)

Client Management has the ability to use custom queries or you can use the easy “Query Builder” (default).  Sometimes it will be required to use a custom query, BCM calls it “Free Query”, to accomplish the desired results.

I created a document in the BMC Communities for Client Management that will help you understand the process. In the example, I am “CONVERTING” a string to a DATE field so I can use a dynamic date. BCM captures the “Last Reboot” value using a WMI query for the class “Operating System”. I want to use the value of “< 1 week”. This query will also show devices that have not rebooted in more than 1 week. Here is the SQL to accomplish this method:

(CONVERT(datetime,OperatingSystem.ATTR_597030) < DATEADD(week, -1,GetUTCDate())

 

Here is the link to the full article I posted that fully explains the process:

Last Reboot – Free Query (Using Dynamic Date)

Click on link to add RSS feed (IE)

How To Use Two Way Integration (Demo using FPSC)

Posted by on Nov 7, 2017 in FPAC | Comments Off on How To Use Two Way Integration (Demo using FPSC)

Many of our customers know BCM can create tickets based on Client Management Integration but not all have begun using this powerful capability. I have created a 22 minute presentation that will detail the process.

Open Demo

The above link will open a new web page.

Using Software License Management to Charge Back Costs

Posted by on Oct 31, 2017 in FPAC | Comments Off on Using Software License Management to Charge Back Costs

Did you know that BMC Client Management has an easy solution to identify all fresh installations of your premium software titles? This allows the IT staff to quickly locate devices that have installed the software that has been entered into the license module. Using your Active Directly OU structure as the method to assign the various Locations/Departments to your selected software title makes it easy to use existing groups.  If your AD structure is not configured based on location or Departments, then you can use the LOCATION field in BCM. If that does not work for your environment, then you can assign a NEW device attribute to each device record displaying the “Charge Code”.

Using a specific query to limit the results returned to populate a report, all newly installed software is returned. Once the device has been “approved” from within the BCM console it will no longer be seen in the report.  This ensures the responsible Department/Location will be charged according to the actual installation.

Here is the process:

  1. Create the Licensed Software Entry in BCM
    1. This can be based on specific version such as Microsoft Office Visio Standard 2010
    2. Add License(s) for either each user to keep track of assigned users or a roll-up of total amount purchased.
    3. Assign Each AD OU under Device Groups (if AD structure is configured based on Financial Requirements)
  2. Assign Report to run on a schedule (Weekly or Monthly depending on size of organization)
  3. BCM Admin will “Change Status” of each device after report is run (reset so new reports will not have duplicates)
  4. Preform required paper work to charge back the proper ORG with copy of report.

Here is a sample of the report:

Click image to see full sized image (opens in new window)

This report only shows two newly installed software titles from the previous week. This makes it very simple to ensure all software is being charged appropriately.

Below is a screen shot showing the process to “Approve” this installation and remove it from the next report:

Click image to see full sized image (opens in new window)

 

Show Buttons
Hide Buttons