| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 02/09/2008 08:32:42
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1451
Location: England
Offline
|
Have you ever wanted the pretty graphs from your SysAid dashboard to be visible whatever you are doing?
Well now you can with my new plugin for yahoo widgets "SysAid LiveStats".
You can place the graphs wherever you like on the screen and can even see through them!
See the screenshot below.
To use this widget first download yahoo widgets from here:- http://widgets.yahoo.com/download/
Then download the attached zip file and extract it to "My Documents/My Widgets" Folder
Go in to My Documents\My Widgets\SysAid LiveStats\Contents and double click on sysaid.kon
You will need to set up a user with read only access to your ilient database supply this username and password and database name in the preferences and away you go!
Notes:-
This is not an official Ilient product, it is my own workings. Feel free to change it at will. If you do anything clever with it post it back to the forum for us all to enjoy.
This version only supports the MS-SQL database, feel free to hack the source for other database types and post the connection
string back to the forum and I wil put them in to future verions.
The toolbar does nothing at all in this version! - you can turn it of in preferences.
You will need to set up a user with read only access to your ilient database.
Have fun!
I will do my best to answer any questions you may have, post any questions you have to this topic, Also post any ideas you have for enhancement (I can't promise I will have time, but we will see).
![[Thumb - livestats.JPG]](/Sysforums/upload/2008/9/2/c238b0a51c3c1de744b90fc43a5f7d1b_73.jpg__thumb)
|
| Filename |
livestats.JPG |
|
| Description |
Screenshot of it in opetation on top google home page |
| Filesize |
103 Kbytes
|
| Downloaded: |
58 time(s) |
| Filename |
SysAid LiveStatsv1.31.zip |
|
| Description |
The Program |
| Filesize |
64 Kbytes
|
| Downloaded: |
34 time(s) |
This message was edited 2 times. Last update was at 03/09/2008 12:08:50
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
03/09/2008 05:57:07
|
Obelix
SysAid Wiz
Joined: 12/06/2008
Messages: 903
Offline
|
Wicked...
*impressed eyes*
|
That is not a bug, it's a feature...
When everything else fail try SysAid Wiki by Techguy |
|
|
03/09/2008 06:13:48
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1451
Location: England
Offline
|
are you going to try it Obelix? I would be interested to know if it works for you.
Maybe I over-estimated demand for such an app as you seem to be the only person who has even shown an interest in it!
If you are not running MS-SQL as your database let me know and we will try and find the right connection string for your db.
This message was edited 1 time. Last update was at 03/09/2008 08:09:56
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
03/09/2008 11:24:09
|
Israel Lifshitz
CEO & Chief Software Architect
Joined: 27/05/2008
Messages: 61
Location: <a >Help Desk Software</a>
Offline
|
Congratulation techguy -- this looks like a great tool ! 
I'm trying to install it now but I need some support:
I receive the attached error message. I'm trying to connect to MS SQL Server. I think its about missing ADO provider. Do you have any instructions on how to install such ADO provider ?
![[Thumb - sysaidwidgets.jpg]](/Sysforums/upload/2008/9/3/43c325bc63c6432cf63efc678b5ad78b_47.jpg__thumb)
|
| Filename |
sysaidwidgets.jpg |
|
| Description |
|
| Filesize |
18 Kbytes
|
| Downloaded: |
6 time(s) |
|
Help Desk Software |
|
|
03/09/2008 11:31:10
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1451
Location: England
Offline
|
oops looks like vista behaves differently to XP. See post below
This message was edited 1 time. Last update was at 03/09/2008 11:59:39
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
03/09/2008 11:58:43
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1451
Location: England
Offline
|
ignore the post above, for it to work on vista the provider connection string needs changing
open main.js
find the line oSqlConnection.open("Provider=SQLNCLI;Data Source=" + servername + ";Database="+database+";Uid="+username+";Pwd="+password+";");
put // infront of the line
and take away the // from the line below
oSqlConnection.open("Provider=sqloledb;Data Source=" + servername + ";Initial Catalog="+database+";User Id="+username+";Password="+password+";");
save main.js and reload the widget.
Or use the new version I have provided below, which has the debug window turned off (ooohps I forgot on the previous release)
| Filename |
SysAid LiveStatsv1.31.zip |
|
| Description |
|
| Filesize |
64 Kbytes
|
| Downloaded: |
21 time(s) |
This message was edited 1 time. Last update was at 03/09/2008 12:07:51
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
06/01/2009 20:38:02
|
Obelix
SysAid Wiz
Joined: 12/06/2008
Messages: 903
Offline
|
techguy wrote:are you going to try it Obelix? I would be interested to know if it works for you.
Maybe I over-estimated demand for such an app as you seem to be the only person who has even shown an interest in it!
If you are not running MS-SQL as your database let me know and we will try and find the right connection string for your db.
Good god... forgive the overlook.
I didn't watch the thread so I missed your question until Lev brought it up again.
It's a great idea bro... but I am looking for something more centralized. If it's for me the portal would suffice.
And no... you do not overestimate. They just probably haven't realized the full potential of it.
I mean one could build their own private NOC with this !
That's universally cool, bro.
When they provide me with my own room and some monitors to spare, I sure will revisit this solution and build my own "command center".
The force is strong with you...
*slight bow and smile*
|
That is not a bug, it's a feature...
When everything else fail try SysAid Wiki by Techguy |
|
|
15/01/2009 04:49:57
|
JSH
SysAider
Joined: 18/08/2008
Messages: 29
Offline
|
VERY NICE!!
This is very usefull - looking forward to see more 
Well, maybe we have to try it our self. Tried to change some of the styles without luck.
|
|
|
15/01/2009 05:09:59
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1451
Location: England
Offline
|
If you tell me what you are trying to change, I may be able to help.
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
11/11/2011 17:21:23
|
wka
Elite SysAider
Joined: 15/07/2010
Messages: 102
Offline
|
What would be nice is if with something like this it would display full screen each chart in turn in a delayed format
Ie chart 1, then after 20 seconds do chart 2 etc
(I realise this is an old post, i've only just found it)
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
![[WWW]](/Sysforums/templates/default/images/icon_www.gif){kind=icon}
![[Yahoo!]](/Sysforums/templates/default/images/icon_yim.gif){kind=icon}
![[MSN]](/Sysforums/templates/default/images/icon_msnm.gif){kind=icon}
![[ICQ]](/Sysforums/templates/default/images/icon_icq_add.gif){kind=icon}
