Skip to main content

Robert Lindley's Blog

Go Search
Home
Services
Calendar
News
Links
Staff
Contact Us
  

ISI > Robert Lindley's Blog

 

Robert S. Lindley

President

rlindley@isi.cc

(501) 217-8484 x101


     

Innovative Systems, Inc. (ISI)
11219 Financial Centre Parkway
Suite 250
Little Rock, AR  72211
http://www.isi.cc

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

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?

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

My Time Today

-- 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

-- 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

-- 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

-- 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)

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

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”)

  1. Get read access to the data
  2. Verify access to the data
  3. ConnectWise Data Dictionary and v_rpt views
  4. Access data using custom SQL statements
  5. Connect custom Time Analysis pivot table to your data
  6. Introduction to Power Gadgets
  7. Connect Power Gadgets to your data

THE STUFF (Right Click to “Save Target As”) Zip file contains:

  1. Time Analysis Excel Pivot Table
  2. 7 Power Gadgets
How to get more from ConnectWise using Microsoft Excel Pivot Tables #HTG #CWPS

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.

Promises not kept!

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

HTG5 is bringing it with 2 Great Webinars TODAY!

clip_image001

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/

1 - 10 Next

 Twitter

  RobertLindley: RT @zenith_infotech: Security alert! Don't press F1 in Windows XP. http://bit.ly/ab6xct
  RobertLindley: Fantastic game. Thank you Canada for a great game as the host. Final USA 2 - CANADA 3 in overtime!
  RobertLindley: USA-USA-USA. 4v4. Sudden dead overtime!
  RobertLindley: YES. TIED 2-2. Overtime!
  RobertLindley: Awesome save for Miller on break away. USA 1 - Canada 2 only 2 minutes to go.
  RobertLindley: USA - USA - USA. Many unanswered shots on goal by Team USA. Great game.
  RobertLindley: @stuartrcrawford Yes, fade Canada. 1 period to go. USA 1 - Canada 2
  RobertLindley: @stuartrcrawford 1 period down 2 to go. Come on USA, score! Canada up 1-0.
  RobertLindley: Getting ready to watch the BCS Championship game. No sure who to pull for? Any ideas?
  RobertLindley: “Plans are worthless, but planning is everything.” Dwight D. Eisenhower #HTG http://bit.ly/6YIEMN
  RobertLindley: “Continuous improvement is better than delayed perfection.” Mark Twain #HTG http://bit.ly/69OHq5
  RobertLindley: RT @asorensen: "Be sure that, as you scramble up the ladder of success, it is leaning against the right building." ~ Steven Covey
  RobertLindley: Enjoying the late Michigan State and Texas Tech football game on ESPN. Great back and forth battle. I watched way too much football today.
  RobertLindley: RT @mlbaxley: That was one of the worst football games I have seen. #fb I agree, Arkansas won in OT ... but it was not pretty!
  RobertLindley: RT @djdaveet What an email to wake up to! I was just named a Microsoft MVP for Virtualization! #HTG
  RobertLindley: Cleaning home office today and watching some TV. Basically a me day. Merry Christmas to all!
  RobertLindley: Join HTG partners TODAY at 11 CST for panel discussion on “Should You Go Vertical?” #HTG #CWPS #MPN http://bit.ly/7hhJdR
  RobertLindley: Robert Lindley (HTG5) is sharing how they focus on the legal vertical and industry associations. http://bit.ly/5KLhbK #HTG #CWPS #MPN
  RobertLindley: Dave Sobel (HTG5, HTG11) is sharing how their vertical focus on virtualization technology. http://bit.ly/5KLhbK #HTG #CWPS #MPN
  RobertLindley: Nick Bock (HTG5) is sharing how their focus on healthcare and banking helped them get on the Inc 500 http://bit.ly/5KLhbK #HTG #CWPS #MPN

 ‭(Hidden)‬ Admin Links