locked
I need to create a webpart that lets the user change to a red/yellow/green light (like a KPI)...? RRS feed

  • Question

  •  

    I want to create a status indicator for some of our IT systems.

     

    Basically instead of calling the help desk to ask "Is The Internet down?", "Is the email server down", "Is the file server down?", "Is the bathroom out of paper towels?", "How much coffee is left in the breakroom coffee pot?", etc...  they can go to a status site and it would just be a list of all of the systems and to the right of them a little Red/Yellow/Green indicator.

     

    Also a column with some comments that they could click on for the full story.

     

    So:  The person in charge of "The Coffee Pot" would see that it is low on coffee and click on that list item and change the color from GREEN to YELLOW and then say "Low on Coffee" for the comments with "Planning to make more coffee in 20 minutes".

     

    Or if the coffee pot was empty it might be red with "OUT OF COFFEE, THE END IS NEAR! ... brewing... come back in 5 minutes..."

     

    You get the idea.

     

    For some of our online database systems that vendors maintain we often have issues with them and it would be great if we could move it to Yellow with a comment saying "Slow today, vendor informed and is working to fix..."

     

    Then people could check that page instead of calling us 10,000 times a day.

     

    How could I go about setting something like that up?  I can't use a KPI as we don't have licenses for that version of MOSS And we wouldn't use them for anything else so it doesn't make sense to do so.

     

    I was thinking maybe a custom list of some sort that I can assign images to for different columns with a preset drop down value as the list of values in a lookup.

     

    Or maybe if I can't use images I could have the system status column's lookup list to say something like: "OK" - which would be in green text.  "Slow" - Yellow text, "Offline" - Red Text.

     

    Something like that and then I could apply conditional rules to the list to handle the colors.

     

    How can I go about making this happen?

     

    Maybe some sort of custom work flow could be used that would add an annoucement to an Annoucement list and each announcement would have a "Relates to System" drop down and that would have a list of all the systems being reported on.

     

    Then someone makes a new announcement, selects the system it relates to, and then this webpart would be a custom view that displays the most recent announcement for each system.

     

    It would also display the "Status" which they would also select (being Red, Yellow, Green).

     

    Perhaps a workflow would be attached to this to automatically fire after an announcement is added and the workflow could programatically adjust the color of the text to based off a conditional decision tree (Offline = Red, OK = Green, etc..)?

     

    Maybe something like that?  I'm really shooting in the dark here sadly...

     

    Thank you!

    Tuesday, July 22, 2008 7:28 PM

Answers

  • I think you could get a quick win by using a custom list.  It could have just a few columns like "system name" and "status".

    Create a view that groups by status and then system.  That will highlight the "green/amber/red" stuff in a list kind of way. 

    There isn't any color coding using this approach, but is probably about as effective.

    You could create addiitonal views as well and put in more columns, such as "ETA to fix" or something.

    --Paul Galvin of www.Conchango.com @ http://feeds.feedburner.com/PaulGalvinsSharepointSpace
    Wednesday, July 23, 2008 2:51 PM
  •  If SharePoint Designer is available he could use conditional formatting + dataview + your custom list to get the color coding.

    http://office.microsoft.com/en-us/sharepointdesigner/HA100996241033.aspx


    Posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, July 23, 2008 6:13 PM

All replies

  • It was a long description above, i manage to read just high level of it. here is what my thoughts are on it,

     

    there is KPI web part available in sharepoint portal 2007 version. you can use it to display red, green, yellow images based on value of your custom list. so it can be done out of box.

     

    You can setup a custom list to add your all required systems or things that people require to see a status. on your home page or some where in your site, only show the one which are down etc. so that people dont see the whole list. Every one who own the system will be responsible to set the value for that system with some comments and some more attributes if you want to if there is any issue with the system or mark it as Fixed once it is up and running. 

     

    you can utilize workflow if you need to add an announcement automatically if some system is marked as down in your list and when it comes back on then remove it from announcement list or you can use workflow to send a reminder emails to relevant owner at defined interval so that they can followup.

     

     

     

    Tuesday, July 22, 2008 7:50 PM
  • If you have a "ticket" system to handle these issues in MOSS already, pull them into a CQWP and setup your "red, amber, green" images based on if-then logic in the XSL.

    So for instance, (pseudocode) if @Status="Down" then <img src="/red.gif"/>
    Wednesday, July 23, 2008 5:10 AM
  • I think you could get a quick win by using a custom list.  It could have just a few columns like "system name" and "status".

    Create a view that groups by status and then system.  That will highlight the "green/amber/red" stuff in a list kind of way. 

    There isn't any color coding using this approach, but is probably about as effective.

    You could create addiitonal views as well and put in more columns, such as "ETA to fix" or something.

    --Paul Galvin of www.Conchango.com @ http://feeds.feedburner.com/PaulGalvinsSharepointSpace
    Wednesday, July 23, 2008 2:51 PM
  •  If SharePoint Designer is available he could use conditional formatting + dataview + your custom list to get the color coding.

    http://office.microsoft.com/en-us/sharepointdesigner/HA100996241033.aspx


    Posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, July 23, 2008 6:13 PM
  • Can you elaborate on that a bit, about the ticketing system?


    ---

    The link to conditional formatting is great: http://office.microsoft.com/en-us/sharepointdesigner/HA100996241033.aspx

    I do have Designer so I'm going to mess with that tutorial next week when I get back into the office.

    Thanks!

    (Once I work it out I'll post back if that solved the problem or not)

    I'm thinking I'll just have my view with:

    System Name, System Status, Notes

    Then it will sory first on System Status (showing the down or degraded ones first) then the System name.

    Any suggestions for the best way to link this to announcements?

    Can I tie it together so that if they create an announcement about the system being down it will automatically flip the status indicator in my custom list?

    So basically the person who updates this page would ALWAYS make a new announcement.

    In that announcement would be a drop down for the system, and a drop down for the system status.

    If they selected "System X" and Status: "DOWN" then in their announcement text they could enter all their notes.

    When they posted that it would automatically update the custom list view.

    When the system is back up they would add a new announcement for System X and set the status to UP or NOMINAL or OK or something.

    How can I also make that happen?

    That would be an ideal situation!

    (Unless maybe the list view is just a custom view of the announcement view where the list view just shows the MOST RECENT Announcement by system and then the announcement list has all the columns where as the custom status list view just has System Name, System Status, and thats it?)
    Friday, July 25, 2008 7:28 PM