Blog

There are two kinds of success —Theodore Roosevelt

Body: There are two kinds of success. One is the very rare kind that comes to the man who has the power to do what no one else has the power to do. That is genius. But the average man who wins what we call success is not a genius. He is a man who has the ordinary qualities that he shares with his fellows, but who has developed those ordinary qualities to a more than ordinary degree. —Theodore Roosevelt Category: Quotes Published: 3/18/2010 5:50 PM

Join HTG partners TODAY at 11 CST for panel discussion on “Should You Go Vertical?” #HTG #CWPS #MPN

Body: WES29PAL: Should you go Vertical? Industry analysts and many Microsoft partners have demonstrated that focusing your solutions to address the specific needs of vertical markets can help your company improve the success of its sales and marketing efforts, improve your competitive positioning, and build sustainable customer loyalty even in a weak economy. In this session, a panel of HTG members Garrett Brucker (HTG15), Nick Bock (HTG5), Dave Sobel (HTG5, HTG11), and Robert Lindley (HTG5) will discuss how they focus on specific vertical market solutions at their company and what this approach has meant to their success.  The panel plans to discuss the following topics: •Why is it important to focus on vertical markets? •Which tools can help you create a vertical strategy? •What is the potential return on investment? •How can you get started? Published: 12/16/2009 8:38 AM

How to get more from ConnectWise using Power Gadgets (Continued) #HTG #CWPS

Body: — My Time Today SELECT ISNULL(SUM(Hours_Actual),0) FROM v_TimeRecords WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX(”,SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX(”,SYSTEM_USER)) AND Date_Start = DATEADD(Day, 0, DATEDIFF(Day, 0, GETDATE())) — My Time This Week SELECT ISNULL(SUM(Hours_Actual),0) FROM v_TimeRecords WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX(”,SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX(”,SYSTEM_USER)) AND Date_Start BETWEEN DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0) AND DATEADD(week, DATEDIFF(week, 0, GETDATE()) +1, 0) -1 — My Utilization This Week SELECT ROUND(ISNULL(SUM(ISNULL(Hours_Actual,0) * ISNULL(Billable_Flag,0)) / SUM(Hours_Actual),0) * 100,0) FROM v_TimeRecords WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX(”,SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX(”,SYSTEM_USER)) AND Date_Start BETWEEN DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0) AND DATEADD(week, DATEDIFF(week, 0, GETDATE()) +1, 0) –1 — My Utilization Last 12 Weeks SELECT DATEPART(ww, Date_Start), ROUND(ISNULL(SUM(ISNULL(Hours_Actual,0) * ISNULL(Billable_Flag,0)) / SUM(Hours_Actual),0) * 100,0) FROM v_TimeRecords WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX(”,SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX(”,SYSTEM_USER)) AND Date_Start BETWEEN DATEADD(week, DATEDIFF(week, 0, GETDATE()) -12, 0) AND DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0) –1 GROUP BY DATEPART(ww, Date_Start) Category: ConnectWise Published: 12/8/2009 8:40 AM Attachments: http://old.isi.cc/rlindley/Lists/Posts/Attachments/103/MyTimeThisWeek_2_5433A9AB.png http://old.isi.cc/rlindley/Lists/Posts/Attachments/103/MyTimeThisWeek_thumb_5433A9AB.png http://old.isi.cc/rlindley/Lists/Posts/Attachments/103/MyTimeToday_2_5433A9AB.png http://old.isi.cc/rlindley/Lists/Posts/Attachments/103/MyTimeToday_thumb_5433A9AB.png http://old.isi.cc/rlindley/Lists/Posts/Attachments/103/MyUtilizationLast12Weeks_2_0220FC64.png http://old.isi.cc/rlindley/Lists/Posts/Attachments/103/MyUtilizationLast12Weeks_thumb_0220FC64.png http://old.isi.cc/rlindley/Lists/Posts/Attachments/103/MyUtilizationThisWeek_2_0220FC64.png http://old.isi.cc/rlindley/Lists/Posts/Attachments/103/MyUtilizationThisWeek_thumb_0220FC64.png

How to get more from ConnectWise using Pivot Tables and Power Gadgets (THE STUFF) #HTG #CWPS

Body: Sorry for the delay in getting THE STUFF to you guys.  Please drop any comments or suggestions on my blog at www.isi.cc/rlindley . Screen Casts: (Click to view Screen cast or right click to “Save Target As”) Get read access to the data Verify access to the data ConnectWise Data Dictionary and v_rpt views Access data using custom SQL statements Connect custom Time Analysis pivot table to your data Introduction to Power Gadgets Connect Power Gadgets to your data THE STUFF (Right Click to “Save Target As”) Zip file contains: Time Analysis Excel Pivot Table 7 Power Gadgets Category: ConnectWise Published: 11/26/2009 3:46 PM

How to get more from ConnectWise using Microsoft Excel Pivot Tables #HTG #CWPS

Body: Step one: Get read access to the data.  Click here to watch the screen cast. Step two: Verify access to the data.  Click here to watch the screen cast. Step three: ConnectWise Data Dictionary and v_rpt Views.  Click here to watch the screen cast. Category: ConnectWise Published: 11/20/2009 10:53 PM

Promises not kept!

Body: I have totally dropped the ball here since ConnectWise Partner Summit.  Deborah and I had no sooner landed in Little Rock from Orlando when we got a phone call from our 26 year old son’s girlfriend.  He had an accident early Sunday morning 11/8 and was taken a local emergency room.  He had multiple broken bones in face below is right eye, missing 2 teeth, stitches in upper lip, and both eyes are heavily brushed.  He had facial reconstruction surgery last week and now has plates in his face to connect the upper jaw and cheek bones together.  His jaw has been wired shut to support the right side for the next several weeks.  He is doing great and should make a full recovery.  Thank you Lord! Needless to say, I have fallen behind at ISI and with promises made regarding “THE STUFF”.  I hope to work on my materials over Thanksgiving holiday.  Please setup an RSS feed on this blog or check back often.  In the mean time here are the PDFs that I posted back in May. ConnectWise Data Analysis Part 1 ConnectWise Data Analysis Part 2 ConnectWise Data Analysis Part 3 ConnectWise Data Analysis Part 4 Here is the PowerPoint from the session: http://www.isi.cc/WebElements/ConnectWise%20Partner%20Summit%202009%20PowerPoint.pdf Category: ConnectWise Published: 11/20/2009 9:19 AM

HTG5 is bringing it with 2 Great Webinars TODAY!

Body: HTG5 Peer Group members are bringing it with 2 Great Webinars Today! Register NOW!!! Microsoft Virtualization: Defined. Building your Virtualization Practice and Solution Offerings Dave Sobel, Evolve Technologies 11/18 at 12:00 PM EST https://training.partner.microsoft.com/learning/app/management/LMS_ActDetails.aspx?ActivityId=510773&UserMode=0 Virtualization is becoming mainstream, and are you ready with your practice? Learn from Dave Sobel, author of “Virtualization: Defined. A Primer for the SMB Consultant”, how to build your consulting practice, get trained and offering solutions, and solutions you can start delivering right away. Learn about server consolidation assessments, Virtual Desktop Infrastructures, and how to deliver high value solutions to your customers. ConnectWise Top Ten Tricks in Managing a Profitable Service Team Cohen Barnes, TBC Net, Inc. Nick Bock, Five Nines Tech Group 11/18 at 1:00 PM EST https://admin.na6.acrobat.com/_a874126979/serviceteambreakout/event/registration.html Join us Wednesday November 18th at 1pm Eastern for an insightful webinar with Cohen Barnes and Nick Bock, break out session presenters from Partner Summit. Among the highest rated sessions at Partner Summit, we invited Cohen and Nick to fly down to beautiful Tampa to do a live show and record this popular session. Cohen and Nick will speak in depth about how to manage a profitable service team. No matter how great your service offering is, if your business isn’t operated effectively and profitability, you may not survive. Get the 10 tricks that will positively affect the fluidity of your business operations and bottom line. These 10 concepts are simple, easy to incorporate into your business structure, and will make a huge difference in your operational costs. If you have an effective plan that utilizes these ten tips, your service team will realize increased profits and provide better service to your clients. Robert Lindley HTG5 Facilitator rlindley@isi.cc 501-217-8484 x101 HTG Peer Groups Business and Personal Growth Driven by Execution http://www.htgpeergroups.com/ Category: ConnectWise Published: 11/18/2009 8:06 AM Attachments: http://old.isi.cc/rlindley/Lists/Posts/Attachments/99/clip_image001_2_20314137.jpg http://old.isi.cc/rlindley/Lists/Posts/Attachments/99/clip_image001_thumb_20314137.jpg

I Want More Than ConnectWise Reports & Dashboards

Body: Here is the session PowerPoint deck.  http://www.isi.cc/WebElements/ConnectWise%20Partner%20Summit%202009%20PowerPoint.pdf Category: ConnectWise Published: 11/6/2009 9:22 AM