Blogs
![]() |
I’m a firm believer in “What gets measured, gets managed.” In our office we have a 42” dashboard in portrait mode attached to an HP Netbook at the end of our main hallway just outside my office and across from our service manager’s desk. This monitor has the a number of gadgets on it from the current time, date, weather, traffic, and a number of metrics from ConnectWise. The bottom 75% of the screen shows the Zenith dashboard.
Unfortunately, the main Zenith dashboard cannot show everything. Several other views from the “Quick Access” tab were needed to complete the picture (ie. Servers, Veritas Backups, and ITS247 Backup). So we could purchase 3 more 42” monitors to have all of the this data visible or we could implement the following PowerShell script to step through each of these dashboards every 15 seconds on one monitor.
Several outstanding problems got addressed the first week we implemented these additional views on our dashboard: servers that where not being patched, backups that where not completing, alerts that had gone unnoticed, etc.) What gets measured, get managed AND gets done.
|
![]() |
Yes, that is $20 taped to the bottom of the monitor. It’s all about accountability, even for the owner. Here is a close up of the note. $10 was just not enough pain. And yes, I have given the $20 away several times. But my first question to the staff member that points out my error and asks for the $20: “Is your time up-to-date?”
|
|
To get this PowerShell script to run, you’ll have to do a few things.
1. Edit the script to contain the correct login and password
2. Set the Powershell execution policy on the machine to RemoteSigned Start Powershell as administrator Run: Set-ExecutionPolicy RemoteSigned Enter Y to confirm 3. Copy to script to a local drive on the machine. 4. Setup startup shortcut to run the script. Open Startup folder Right-click, New, Shortcut… Enter the location as: powershell –f “c:pathtoscriptZenithDashboard.ps1″ Next Enter a name for the shortcut Next Right-click the shortcut, click Properties Set “Run” to “Minimized” |
|
| Here’s the PowerShell script:
# Settings:
$URL = “https://control.itsupport247.net/” $Seconds = 5 # Number of seconds between refreshes $Username = “xxxxxxxxxxxx” $Password = “xxxxxxx” # End Settings
# # Innovative Systems, Inc. # 11219 Financial Centre Parkway # Little Rock, AR 72211 # http://www.isi.cc # info@isi.cc # (501) 217-8484 # Stop on error
$ErrorActionPreference = “Stop” # Function to wait for IE to not be busy after clicking a link
function WaitOnIE { while($IE.Busy) { Start-Sleep -Milliseconds 100 } } # Function to find a link based on it’s text, then click it.
function ClickLink($LinkText) { # Find all A tags with InnerHTML containing the $LinkText. # In the case that there are multiple found, only select the first one. $Link = $IE.Document.getElementsByTagName(“a”) | ?{$_.InnerHTML -like “*$LinkText*”} | select -First 1 # Make sure the link was found. Clicking $Link if it was null would throw an error if($Link) { $Link.Click() } WaitOnIE } # Create IE ComObject, navigate to URL, and make it visible
$IE = New-Object -ComObject internetexplorer.application $IE.Navigate($URL) $IE.Visible = $true WaitOnIE # Fill login and submit
$IE.Document.getElementById(“user_txt”).Value = $Username $IE.Document.getElementById(“user_pass”).Value = $Password $IE.Document.getElementById(“Submit”).Click() WaitOnIE # Comes up to dashboard, so sleep before starting the loop
Start-Sleep -Seconds $Seconds # Loop through screens
while($true) { # Click Quick Access ClickLink -LinkText “Quick Access” Start-Sleep -Seconds $Seconds # Click Veritas Backups
ClickLink -LinkText “Veritas Backups” Start-Sleep -Seconds $Seconds # Click ITS247 Backup
ClickLink -LinkText “ITS247 Backup” Start-Sleep -Seconds $Seconds # Click Dashboard
ClickLink -LinkText “Dashboard” Start-Sleep -Seconds $Seconds } |
http://www.isi.cc/files/2011/01/b3842baabe5fb843.jpg
http://www.isi.cc/files/2011/01/1a64a1f5645fb843.jpg
http://www.isi.cc/files/2011/01/bd88574a544d0afb.jpg
|
|
ConnectWise |
|
|
|
|
|
||||
|
|
||||
|
|
||||
|
|
||||
|
ConnectWiseTV: What Gets Measured, Gets Managed Join us this Wednesday April 14th at 12 noon Eastern for an informative ConnectWise TV show with Robert Lindley, President of Innovative Systems, Inc. and 2009 Partner Summit presenter. Both of Robert’s breakout sessions at the summit were maxed out and voted the session that partners most wanted to see but couldn’t. Robert will review some of the materials from his breakout session and share additional metrics he has developed in the last 6 months to run his managed services practice. He will also discuss how he has implemented some of the concepts learned from keynote speaker Verne Harnish at the summit. Are you getting all of the information you need to run your business from ConnectWise reports and dashboards? Is that information allowing you to make decisions regarding your business today that are not based upon last month’s or last quarter’s data? Have you set your top 5 priorities for your business this year? How will you measure your performance? How often will you review it with your staff? And do their top 5 priorities line up with yours? In this session, Robert will review how he is using Microsoft Excel Pivot Tables, SQL Reporting Services, SharePoint, and Software F/X PowerGadgets to measure each staff member’s performance and their alignment with ISI’s overall business objectives. Presentation materials including a whitepaper and example pivot tables, reports, gadgets, etc. will be made available for download after the show, on our University, with the recording of the show. If there are any questions, please don’t hesitate to contact us. We will be recording this live show and posting it on the ConnectWise University soon. We are committed to helping you build your business! |
||||
|
|
||||
WES36PAL: Four Plans That Can Change Everything
Wednesday 3/24/2010 12:00 AM EST
Learn about the importance of planning for your business, leadership, life and legacy. Understand the value of integrating the quarterly planning into how you run your company and your life, and the true meaning of the saying, “He who fails to plan, plans to fail.” These are proven and valuable planning tools that will help assure success if you use them to drive business and personal growth through execution. Partners will receive 4 planning worksheets that walk them through the steps of creating these four plans.








