dkmartini

hey todd, i responded to the other post you made as well. The issue is version of pg. look in the connectsmart forum for more info. Search windows7

hey todd, the problem (I am pretty sure) is that the release version of PowerGadgets doesn't properly support PowerShell V2. Certain elements work but others do not, eg size, drill down etc. You will need to be on 1.0.3588.x or later for it to work. Post this on the ConnectSMART forum for more info

sorry for the braindead - extra space got between the "-" and the drilldown parameter

Hi, I started w/ this script ----- $SQL = "SELECT DISTINCT sr_status as Status, COUNT(*) AS TicketsFROM v_CBI_Open_TicketsWHERE (Company_Name <> 'ConnectWise') GROUP BY sr_status" invoke-sql -server cw -database cwwebapp_connections -sql $sql | out-chart -template opentickets -caption "Open Tickets" -Title "Open Tickets" -sidebar tickets -group tickets -name "Open Tickets" -drilldown_script allTicketsDrillDown.ps1 -drilldown_parameter {$_.status} ------ changed it to this script to be able to specify the colors of each bar in the chart ------- function getColor{ if ($args[0] -eq 'Enter Time') { return 'Yellow' } if ($args[0] -eq 'Scheduled') { return 'Green' } if ($args[0] -eq 'Completed') { return 'Green' } if ($args[0] -eq 'Done Yet?') { return 'Red' } return 'Blue'} $SQL = "SELECT DISTINCT sr_status as Status, COUNT(*) AS TicketsFROM v_CBI_Open_TicketsWHERE (Company_Name <> 'ConnectWise') GROUP BY sr_status" $items = invoke-sql -server cw -database cwwebapp_connections -sql $sql$clr0 = getColor $items[0].Status$clr1 = getColor $items[1].Status$clr2 = getColor $items[2].Status$clr3 = getColor $items[3].Status$clr4 = getColor $items[4].Status$clr5 = getColor $items[5].Status$clr6 = getColor $items[6].Status$clr7 = getColor $items[7].Status$clr8 = getColor $items[8].Status$clr9 = getColor $items[9].Status$clr10 = getColor $items[10].Status$clr11 = getColor $items[11].Status$clr12 = getColor $items[12].Status $items | out-chart -allseries_multiplecolors true -points_0_color $clr0 -points_1_color $clr1 -points_2_color $clr2 -points_3_color $clr3 -points_4_color $clr4 -points_5_color $clr5 -points_6_color $clr6 -points_7_color $clr7 -points_8_color $clr8 -points_9_color $clr9 -points_10_color $clr10 -points_11_color $clr11 -points_12_color $clr12 -template opentickets -caption "Open Tickets" -Title "Open Tickets" -sidebar tickets -group tickets -name "Open Tickets" -drilldown_script allTicketsDrillDown.ps1 - drilldown_parameter {$_.status} --------------- Now my drilldown doesn't work. What am I missing? Thanks dkm