T_Noble

Hi all, Looking for something that I can either intergrate to GP managment or something that is already built in that will act as a change control. Whether this be something that compares the old GP and then writes a text file detailing all of the changes that have been made and the date on which they were made, or if you get a pop up box (like is Microsoft Firewall Client) that asks you to detail your changes. Any ideas? Kind Regards Tom

How long did it take you to make your own? Is there any chance that you could post the creation steps on here for me and so I can try and follow the same procedure? You can of course find out the session name, this is done by looking at the username of the current user logged in. The "net.username" command works in .bat and VBscripts so I presume you can either make one of those to report back the username or put something similar in your backend. Here is a code snippet that I am using for a web based login tracker that uses the above code: ' Gather required information strLUsername = net.username strLComputer = net.computername We found that spiceworks is very resource heavy, it could really do with alot of the features turned off and then allowing you to turn them on when needed. We found there are alot of features that you can turn off, but even then they still load. Kind Regards Tom

We are currently using spiceworks at the moment but finding it a very slow application to run. The loading times on the web interface aren't that good and a bespoke setup would have greater benifits.

We are going to be making one. At the moment I am just making the front end gadget, the basic bits that will communicate with the sql server.

Hi all, Been talking to the rest of the ICT team here and we are looking at implementing a helpdesk gadget when we distribute windows 7 across the school. I am the lucky one faced with this project. A bit of background to the gadget coding (as far as I understand it): Requires HTML Code JScript Gadgets Services to be running Stored in the "Sidebar" folder with a .gadget folder So far I have managed to create something that loads up a small screen, that can be moved anywhere on the desktop, with our school logo in it. You then click a button placed within the window and get taken to a larger window with a form inside. I have placed basic HTML buttons for "submit" and "reset" at the bottom. The things currently not working and the things I think need to be done to get them running: Submitting the information - JScript Going back to the original splash screen Sending information back to an SQL Server What I have at the moment, even though it is just very basic base code and doesnt really do anything, is attached to this post. Kind Regards Tom HelpDesk.gadget.zip

I am hoping that the MINAGE part is going to work. This is something I cannot test until this time next week, as I dont have a file in that folder that is more than a week old. Does it look at the File Modified Date attribute to work out if it is over a week old? Kind Regards Tom

Hi All, Been working on another project. I am looking for a piece of code, to put in a .bat file, that does the following: *Filename* is stored like the following example "19-01-2010--14-51.sql" ---- Looks at the current date If C:\LoginTrackerBackups\*Filename* is 7 days or older than the current date DeleteFile Else Move onto the Next file End ---- Kind Regards Tom

Thanks for all help so far. I now have the following code: "C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe" -u --root --password=MYPASSWORD logintracker < C:\Inetpub\wwwroot\logintracker\logintracker\logintracker.sql Telling me there is an error with the username and password syntax. In addition to this, do I need to put " " around the dir for the sql script? Regards Tom

I am trying to do the above with this piece of code: C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe -u MYUSERNAME -p MYPASSWORD logintracker < logintracker.sql However I get an error: "The system cannot find the spercified file". Any ideas? The logintracker.sql file is stored in the same directory as the mysql.exe (C:\Program Files\MySQL\MySQL Server 4.1\bin\logintracker.sql). Kind Regards Tom

Hi All, Have a server setup which is running phpmyadmin 2.11.10 and MySql Server 4.1.22. Stored on the local drive there is a SQL Query that I want to run. I can run this manually by "importing" the SQL Query, or copying and pasting it into the Query window for the particular database. (Called LoginTrackerDatabase). What I want to do, is set up a schedule so this runs everyday. Can this be done through windows task scheduler? Thanks in advance for all replies. Regards Tom

Both the thanked replies work well. ' Gather required information strLUsername = net.username strLComputer = net.computername strLDate = CStr(Date) strLTime = CStr(Time) strOU = LCase(GetDN) FirstCharacter = Left(strLUsername, 1) If isNumeric(FirstCharacter) Then strType = "student" Else strType = "staff" End If and If FirstCharacter >= "1" And FirstCharacter <= "9" Then StrType = "student" Else StrType = "staff" End If Kind Regards All Tom

Could I use the following (Working on code from both the above replies)? ' Gather required information strLUsername = net.username strLComputer = net.computername strLDate = CStr(Date) strLTime = CStr(Time) strOU = LCase(GetDN) FirstCharacter = Left(strLUsername, 1) If FirstCharacter = "[1-9]" Then strType = "student" Else strType = "staff" End If Regards Tom

Hi all, First post on here, so hoping that I have it right. I have the following code (Written in VBS): ' Gather required information strLUsername = net.username strLComputer = net.computername strLDate = CStr(Date) strLTime = CStr(Time) strOU = LCase(GetDN) If InStr(staff, user.Description) Then strType = "staff" Else strType = "student" End If I want it to do the following: If First Character of the username is an integer (1-9) Then StrType = "student" Else StrType = "staff" End If Thanks for any replies in advanced. Kind Regards Tom