Creating SharePoint Dashboard using Chart WebPart

Hi All,

Today I am sharing an automated solution that I have created using powershell & sharepoint Chart webpart.

I have to share the whole solution as without it relevance of script will not be understood as I desire.

We have created a tracker List for SIP (service improvement plan) for each of the tracks.

below is the screenshot of the list:-(SIPs)

sip1

Based on this tracked we have made the dashboard for all the tracks

sip2

Now create the 4 custom Lists to hold the data for chart webpart:-

 

Total SIPS

Sips Status

Sips in Progress

Sips Closed by Tower

Here is one of the example:-

sip3

After making these lists & associating it to chart webpart, I have made a shell script to update these list on schedule basis.

This solution can be downloaded from below location:-

http://gallery.technet.microsoft.com/scriptcenter/SharePoint-Dashboard-using-09d29fd1

Code used in script:-

###############################################################################
# Authors: Vikas Sukhija
# Date: 08/12/2013
# Description: Script to update sharepoint lists on SIP site
# This will enable updating of DashBoard
###############################################################################

If ((Get-PSSnapin | where {$_.Name -match “SharePoint.Powershell”}) -eq $null)
{
Add-PSSnapin Microsoft.SharePoint.Powershell
}
$date = get-date -format d
$date = $date.ToString().Replace(“/”, “-”)

$siteurl = “http://sharepointlab/sites/SIP”
$ListName = “SIPs”

##################################Get List##########################

$spWeb = Get-SPWeb $siteurl
$list = $spWeb.Lists[$ListName]
$items = $list.getitems()
####################################Create Count variables############
$Collection=@()
#####################Total SIPs######################################
function TotalSips ($IsTower) {
foreach($item in $items)

{

if($item[“IS Tower”] -eq $IsTower)
{
$Collection += $item.Name

}

}
Write-host $Collection.count
$output = “.\Dashboard\” + $IsTower + “-” + “Totsip” + “_.txt”
$Collection.count | out-file $output

}

###########################Sips Closed by Tower##########################

function sipsclosedbytower ($IsTower) {
foreach($item in $items)

{

if(($item[“IS Tower”] -eq $IsTower) -and ($item[“SIP Status”] -eq “Closed”))
{
$Collection += $item.Name

}

}
Write-host $Collection.count
$output = “.\Dashboard\” + $IsTower + “-” + “sipclbt” + “_.txt”
$Collection.count | out-file $output

}

###########################Sips in-progress by Tower##########################

function sipsinprogressbytower ($IsTower) {
foreach($item in $items)

{

if(($item[“IS Tower”] -eq $IsTower) -and ($item[“SIP Status”] -eq “In Progress”))
{
$Collection += $item.Name

}

}
Write-host $Collection.count
$output = “.\Dashboard\” + $IsTower + “-” + “sipinprgt” + “_.txt”
$Collection.count | out-file $output
}

################################Total Active,Closed,progress,Proposed,Rejected######

function sipstatus ($SIPSTATUS) {
foreach($item in $items)

{

if($item[“SIP Status”] -eq $SIPSTATUS)
{
$Collection += $item.Name

}

}
Write-host $Collection.count
$output = “.\Dashboard\” + $SIPSTATUS + “-” + “sipst” + “_.txt”
$Collection.count | out-file $output

}

####################################################################################

TotalSips Messaging
TotalSips Windows
TotalSips Unix
TotalSips DBA
TotalSips DCO
TotalSips Storage
TotalSips Montioring
TotalSips Tools
TotalSips Voice
TotalSips Network
TotalSips Security
TotalSips Helpdesk
TotalSips Remedy
TotalSips Process
TotalSips WSM

sipsclosedbytower Messaging
sipsclosedbytower Windows
sipsclosedbytower Unix
sipsclosedbytower DBA
sipsclosedbytower DCO
sipsclosedbytower Storage
sipsclosedbytower Montioring
sipsclosedbytower Tools
sipsclosedbytower Voice
sipsclosedbytower Network
sipsclosedbytower Security
sipsclosedbytower Helpdesk
sipsclosedbytower Remedy
sipsclosedbytower Process
sipsclosedbytower WSM

sipsinprogressbytower Messaging
sipsinprogressbytower Windows
sipsinprogressbytower Unix
sipsinprogressbytower DBA
sipsinprogressbytower DCO
sipsinprogressbytower Storage
sipsinprogressbytower Montioring
sipsinprogressbytower Tools
sipsinprogressbytower Voice
sipsinprogressbytower Network
sipsinprogressbytower Security
sipsinprogressbytower Helpdesk
sipsinprogressbytower Remedy
sipsinprogressbytower Process
sipsinprogressbytower WSM

sipstatus Active
sipstatus Closed
sipstatus “In Progress”
sipstatus Proposed
sipstatus Rejected
#####################################Update Towers List#################################

Function dashupdatelist ($ISTower)
{

$ListName = “Towers”
$list = $spWeb.Lists[$ListName]
$items = $list.getitems()

$input1 = “.\Dashboard\” + “$ISTower” + “-” + “Totsip” + “_.txt”
$value = get-content $input1
write-host $value

foreach($item in $items)
{
if($item[“IS Tower”] -eq $ISTower)

{
if($item[“TotalSips”] -ne $value)
{

$item[“TotalSips”] = $value;
$item.update();

}

}
}
}

#####################################Update sip closed by towers List##########################

Function dashupdatesipcltlist ($ISTower)
{

$ListName = “SIPClosedTower”
$list = $spWeb.Lists[$ListName]
$items = $list.getitems()

$input1 = “.\Dashboard\” + $ISTower + “-” + “sipclbt” + “_.txt”
$value = get-content $input1
write-host $value

foreach($item in $items)
{
if($item[“IS Tower”] -eq $ISTower)

{
if($item[“Count”] -ne $value)
{

$item[“Count”] = $value;
$item.update();

}

}
}
}

#####################################Update sip inprogress by towers List##########################

Function dashupdatesipinpltlist ($ISTower)
{

$ListName = “SipsInProgressbyTowers”
$list = $spWeb.Lists[$ListName]
$items = $list.getitems()

$input1 = “.\Dashboard\” + $ISTower + “-” + “sipinprgt” + “_.txt”
$value = get-content $input1
write-host $value

foreach($item in $items)
{
if($item[“IS Tower”] -eq $ISTower)

{
if($item[“Count”] -ne $value)
{

$item[“Count”] = $value;
$item.update();

}

}
}
}

#####################################Update sip status List##########################

Function dashupdatesipstsltlist ($SIPSTATUS)
{

$ListName = “InProgress”
$list = $spWeb.Lists[$ListName]
$items = $list.getitems()

$input1 = “.\Dashboard\” + $SIPSTATUS + “-” + “sipst” + “_.txt”
$value = get-content $input1
write-host $value

foreach($item in $items)
{
if($item[“Sip Status”] -eq $SIPSTATUS)

{
if($item[“Count”] -ne $value)
{

$item[“Count”] = $value;
$item.update();

}

}
}
}

#########################################Call Function##########################################
dashupdatelist Messaging
dashupdatelist Windows
dashupdatelist Unix
dashupdatelist DBA
dashupdatelist DCO
dashupdatelist Storage
dashupdatelist Montioring
dashupdatelist Tools
dashupdatelist Voice
dashupdatelist Network
dashupdatelist Security
dashupdatelist Helpdesk
dashupdatelist Remedy
dashupdatelist Process
dashupdatelist WSM

dashupdatesipcltlist Messaging
dashupdatesipcltlist Windows
dashupdatesipcltlist Unix
dashupdatesipcltlist DBA
dashupdatesipcltlist DCO
dashupdatesipcltlist Storage
dashupdatesipcltlist Montioring
dashupdatesipcltlist Tools
dashupdatesipcltlist Voice
dashupdatesipcltlist Network
dashupdatesipcltlist Security
dashupdatesipcltlist Helpdesk
dashupdatesipcltlist Remedy
dashupdatesipcltlist Process
dashupdatesipcltlist WSM

dashupdatesipinpltlist Messaging
dashupdatesipinpltlist Windows
dashupdatesipinpltlist Unix
dashupdatesipinpltlist DBA
dashupdatesipinpltlist DCO
dashupdatesipinpltlist Storage
dashupdatesipinpltlist Montioring
dashupdatesipinpltlist Tools
dashupdatesipinpltlist Voice
dashupdatesipinpltlist Network
dashupdatesipinpltlist Security
dashupdatesipinpltlist Helpdesk
dashupdatesipinpltlist Remedy
dashupdatesipinpltlist Process
dashupdatesipinpltlist WSM

dashupdatesipstsltlist Active
dashupdatesipstsltlist Closed
dashupdatesipstsltlist “In Progress”
dashupdatesipstsltlist Proposed
dashupdatesipstsltlist Rejected

###########################################################################################################

Regards

Sukhija Vikas

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s