Configuration Manager Web Frontend Update 1.0.4

This update addresses a few bugs that people have encountered since the last update. If you already have the frontend installed download the update for your version of ConfigMgr. Updated full versions are also available below.

Change log

  • ConfigMgr 2012 and 2012 r2 supported under same installation.
  • Initial inventory scan for sites with a large number of clients now works.
  • Added database prefix option for sccm installations that use SMS_<sitecode> or something else rather than the default CM_<sitecode>.
  • Added a debug logging option.

Downloads

Installation

To perform this update run update.ps1 in an elevated Powershell session.

Configuration Manager Web Frontend Update 1.0.3

I have been meaning to post this update for a while now. This is a small update that mainly addresses installer script issues and 2012 R2 support. If you already have the frontend installed download the update for your version of ConfigMgr. Updated full versions are also available below.

Change log

  • ConfigMgr 2012 R2 support
  • Fixed installer bugs
  • Added application filters to the site
  • A few style changes

Downloads

Installation

To perform this update run update.ps1 in an elevated Powershell session.

Configuration Manager Web Frontend

Update (01/27/2014): I have updated the installation files to the latest version (1.0.4)

Back in SCCM 2007 and SMS 2003 there was a popular community tool by Ron Crumbaker called web remote tools that would allow help desk staff to easily deploy software and access tools for a computer without having access to the console. With the new appmodel and other changes in SCCM 2012 these tools no longer work. Since Ron’s project has been stale for very long time I decided to create a modern replacement.

Configuration Manager Web Frontend (CMFrontend) is a HTML5 web application designed to provide quick access to information, tools, and deployments without the use of the Configuration Manager console.

CMFront_1 CMFront_2 CMFront_3

Features

  • Deploy both Applications and Packages
  • Quick computer information
  • Remote tools
  • Role based administration support
  • Realtime deployment status

Download & installation

CMFrontend can be downloaded here:

The installation is mostly automated but there are a few prerequisites that must be in place. Check the readme inside the zip file for more details.

Note: CMFrontend requires a new server 2012 VM to be setup.

How it works

CMFrontend uses a windows service and an asp.net mvc4 website to connect to the ConfigMgr management point and sql server in order to perform its actions. Most data is cached via an SQL database so that the service does not create excessive load on the management point.

Application deployments are performed by a specified service account that automatically creates a collection and a deployment for each program deployed per RBAC group.

CMFront_4

The tools are launched from the browser using a java applet. I have included the source code for this applet for any security concerns / repackaging & resigning.

What is next

  • Better / more detailed deployment updates
  • Applications tab which lets you view your computers from the application rather than the collection
  • Application list filtering

Computer Warranty Info (Formerly Dell Warranty Info)

Update 08/25/16: Both Dell and Lenovo functions have been updated and are currently working. API key in the Dell function may expire overtime and will need to be replaced.

Update 07/28/16: Looks like Dell has replaced their older warranty lookup service with a new API. I am currently in the process of re-writing the script and hope to have it online soon.

Update 02/25/16: Lenovo changed the way their warranty lookup pages works a few months ago. The script has been updated so that it works with those new pages.

Update 08/05/14: File is actually updated this time and now contains the fixes mentioned in previous update.

Update 07/25/14: Fixed Get-DellWarrantyInfo, It appears as if Dell changed the WSDL to point to an internal address. A workaround has been added. Redownload the script to get the correction.

Update 05/23/14: All lenovo warranty issues have been fixed (for now). Redownload the script if you have lenovo systems.

This package provides easy, scriptable access to Dell and Lenovo warranty information and includes an example on how it can be used to power ConfigMgr 2012 reports.

Back in 2011 I created a dell warranty powershell module that would use Dell’s web service to gather warranty info. Using that module I created two scripts that could be used with ConfigMgr to gather warranty data for reporting. Now that most people are using ConfigMgr 2012 I have had many requests to update them as they currently do not work.

In this new version a few things have changed.

  • Lenovo support has been added. (Get-LenovoWarranty)
    • This is an html scraper and might break in the future.
    • Lenovo’s web servers are very sketchy.
  • ConfigMgr 2012 support.
  • The SQL script has been improved.
    • Data is now stored in its own database.
    • The script will only query for warranty info that is missing.
  • The WMI hardware inventory script has been removed.

You can download the new scripts here: https://utexas.box.com/computerwarrantyinfo

ComputerWarrantyInfoFunctions.psm1

This powershell module contains two functions that will allow you to gather warranty info from both Dell and Lenovo systems. The required info to look up the warranty information can be automatically gathered from the computer itself, or directly inputted. This module does not require ConfigMgr. Feel free to use this module in your own scripts if you desire.

get-DellWarranty [[-computer] <String>] [[-logFilePath] <String>] [-ServiceTagInput]

Example 1 – Get dell warranty information using a computer name

Get-DellWarranty MyComputerName

Example 2 – Get dell warranty information using a list of service tags

Get-Content .\servicetags.txt | Get-DellWarranty -ServiceTagInput

get-LenovoWarranty [[-computer] <String>] [[-logFilePath] <String>] [-TypeSerialInput]

Example 1 – Get Lenovo warranty information using a computer name

Get-LenovoWarranty MyComputerName

Example 2 – Get Lenovo Warranty information using a list of system types and serials.

Get-Content .\TypesAndSerials.txt | Get-LenovoWarranty -TypeSerialInput

ComputerWarrantyInfoSQL.ps1

This script will query the ConfigMgr database for Dell and Lenovo systems and store their warranty information in its own database using the Computer Warranty Info module. On subsequent runs only the systems that are still missing warranty info will be run. This script should be run on a regular schedule for best effect. This script has not been tested with ConfigMgr 2007.

Usage

  1. Run the following powershell using a user who has read permissions on the ConfigMgr database and the ability to create databases on the server itself.
    .\ComputerWarrantyInfoSQL.ps1 -SqlServer mysqlserver.abc.def -SiteCode ABC
    
  2. Set this command to run on a schedule if you wish.

The Report

As we all know creating reports in ConfigMgr 2012 takes much more effort than it did in 2007. I have included an export of a very basic report for you to use as a starting point. I recommend changing it to suit your needs as it is very basic and mainly for example.

installation

  1. Add your report viewer service account with read access to the database created by the sql script (ComputerWarranty).
    create user 'yourreportvieweraccount' for login 'yourreportvieweraccount'
    exec sp_addrolemember 'db_datareader', 'yourreportvieweraccount'
    
  2. Open Computer Warranty Info.rdl with report builder (use a user that has access to the ConfigMgr database)
  3. On the left, right click on data sources and hit add data source…
  4. In the Data source properties window, hit browse.
  5. Navigate the your report server’s configmgr_sitecode.
    1. Should look something like this: http://sqlserver/reportserver/ConfigMgr_sitecode
  6. Double click on the data source in the folder. It will have a unique guid as the name.
  7. Ok out of the dialog.
  8. Right click on dataset1 and goto properties.
  9. Make sure that Datasource1 is the selected data source.
  10. Do the same for dataset2.
  11. Go ahead and run the report. If you have no errors save the report to your report server.

warranty