Solved

Find username with vbscript using server session's for query

Posted on 2009-05-06
29
1,345 Views
Last Modified: 2012-05-06
Hi

In the computer management window of a fileserver, under "shares", you can rightclick on  "sessions" and export a list of the current sessions. These include the username and IP/computername that are currently connected along with some other useful data.

I would like to make use of this information without have to go onto the server and check all the time.

The script should first off give an input box where servername is typed.
I would then like the script to make this export command for the sessions on server specified, but export the list to the desktop on the machine from where the script is executed.

When this list is exported it should be in a format so that "text to colums" is performed.
it should as a final stage open this file for review.

If the script is executed a second time, it should overwrite the cvs or xls file with new information so that it only contains current data.

Thanks in advance /Dabosa

0
Comment
Question by:Dabosa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 18
  • 11
29 Comments
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24315152
which do you want csv or xls?  Also keep in mind that Excel will need to be on the machine executing the script inorder for it to pull up.  Also You need to make sure that the other machines have WMI controls installed to them which server 2k3 doesnt by default go into the ad remove compents area to fix this.  I will go ahead and start this for you though, may take a little while
0
 

Author Comment

by:Dabosa
ID: 24315391
Hi

xls would be prefered

there are to componets to add, should i tick both of them?

1. WMI SNMP Provider
2. WMI Windows installer provider


Thanks /David
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24315452
Do you want to watch it make the XLS?  Do you want it sorted or formated in any particular way IE alternating row colors, Outlines, No Grid Line etc.  I should have it done in about an hour or two depending on how busy work keeps me
0
Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24315480
You may not need it.  I remebered I had to turn on the installer part when I was scripting to document server specs.  You can try w/o and if you need to add the installer 1st then snmp if you need to.  There is no need to add features if they are not needed
0
 

Author Comment

by:Dabosa
ID: 24315520
Ok  will wait with install wmi .

How do you mean watch it make the xls, it sounds cool, so yes if it is:)?

No need for doog looking format, just so that the information is column based.
i will use it wehn i need to see which ip and how long a user have been connected to a particual server.

Thanks /D
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24315549
ok no problem,  sometimes I get a little overboard, Be ready in a bit
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24315613
How do you want the columns orderd?  Ie Computer | Time Connected | Idle Time | Name | User
0
 

Author Comment

by:Dabosa
ID: 24315649
in the same format as when checking the export file when doing it manually

which is:

user, computer, type, #open files, Connected time,idle time, guest.

 If you could take a moment to very briefly explain in the code,  what part is doing what,  it would be much appriciated as im just starting out writing vbscript.

Thanks again /D
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24315761
No worries I comment erverything very well ( but thats my opinion) I would be happy to explain all of though when I am done.  Do you want to save the Excel file with in the script? or would you rather use File Save As from with in excel when it is done?
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24315788
I will not be able to extract type though it looks like the MSDN documentation will not allow for it

http://msdn.microsoft.com/en-us/library/aa746332(VS.85).aspx
0
 

Author Comment

by:Dabosa
ID: 24315790
ok thats good!! I would prefer the script to save it as jfinner.xls

Thanks /D
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24316230
ok
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24316570
How important is the # of open files?  If you need it I will have to look it up and see if I can do this another way
0
 

Author Comment

by:Dabosa
ID: 24316934
thats not important, nor is guests.
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24316939
Kool Then its just about done I need to tell it to save have to you in apporx 5 min
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24317121
Here is everything but the file.  Though you may want to play with the script before I finsih.  I am running out to lunch will add the extra line or two when I return
'==========================================================================
'
' VBScript Source File -- Created with SAPIEN Technologies PrimalScript 2007
'
' NAME: OPen_Sessions_To_CSV
'
' AUTHOR: John Finner , GWFH
' DATE  : 5/6/2009
'
' COMMENT: 
'
'==========================================================================
'Global Variables
'=============================================================================================
Dim oConnection,oExcel,oRange
Dim sComputerName
Dim iRow : iRow = 2
'=============================================================================================
'Constants for Excel Formatting
'=============================================================================================
Const xlCenter = -4108
Const xlBottom = -4107
Const xlContext = -5002
'=============================================================================================
 
'Input box for Server Name
'=============================================================================================
sComputerName  = InputBox ("Please enter FQDN of Machine to be scanned","Get Open Sessions")
'=============================================================================================
'Connect to WMI on remote machine
'=============================================================================================
Set oConnection = GetObject("WinNT://" &sComputerName& "/LanmanServer")
Set colSessions = oConnection.Sessions
'=============================================================================================
'Initialize Excel and Format Header row
'=============================================================================================
Set oExcel = CreateObject("Excel.Application")
With oExcel
	.Visible = True
	.Workbooks.add()
	.Cells(1,1).value = "User"
	.Cells(1,2).value = "Computer"
	.Cells(1,3).value = "Connected Time"
	.Cells(1,4).value = "Idle Time"
	End With
'=============================================================================================
'Populate Spread sheet using iRow as the control
'=============================================================================================
For Each oSession in colSessions
	With oExcel 
	      .Cells(iRow,1).value = oSession.User
	      .Cells(iRow,2).value = oSession.Computer
	      .Cells(iRow,3).value = oSession.ConnectTime
	      .Cells(iRow,4).value = oSession.IdleTime
	End With
	iRow = iRow + 1
Next
'=============================================================================================
'Finalize and Save Spreadsheet
'=============================================================================================
		'Format Header Row
	'=================================================================================
	  Set oRange = oExcel.Range("A1:D1")
	  oRange.Font.Bold = True
	  With oRange
		.HorizontalAlignment = xlCenter
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
	  End with
	'=================================================================================
	'Autofit Page
	'=================================================================================
	 Set oRange =  oExcel.Range("A:D")
	 oRange.EntireRow.Autofit()
	 oRange.EntireColumn.Autofit()
	'=================================================================================
 
'=============================================================================================
Function GetEnvirmomentVariable(tmp)
Dim  objShell
Set objShell = CreateObject("WScript.Shell")
GetEnvirmomentVariable = objShell.ExpandEnvironmentStrings(tmp)
End Function
	

Open in new window

0
 

Author Comment

by:Dabosa
ID: 24317195
very nice! only thing is to get the time in a readable format.

Excellent job!
0
 

Author Comment

by:Dabosa
ID: 24317205
no wmi controls needed to install on server
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24317894
What do you mean by readable format?  
0
 

Author Comment

by:Dabosa
ID: 24323409
The time is now displayed in min i think. Would be good if possible to have the format Days:Hrs:min
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24324718
Sure Can not hard at all will repost along with the feature to save to %userprofile%/jfinner.xls  Also was the code broken down in a format you could follow I would be happy to give you a line by line blow if you need me to
0
 

Author Comment

by:Dabosa
ID: 24324858
Excellent, yes the more information the better:)
Im also curios how you know what properties to use?

Like:

Set oConnection = GetObject("WinNT://" &sComputerName& "/LanmanServer")
Set colSessions = oConnection.Sessions

Are you finding those with what refrence, in primalscript?

Thanks /D
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24325138
I think I spoke too soon this might take a miniute or so, not as easy as i thought
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24325263
In regards to set oConnection = ...........  oConnection is an object, created on the pc running the script.  It connects to an object on a remote PC definefined by sComputername to its LANMAN services, which is the file IO service.  Every object has methods and properties and sub methods and properties to each of those.  the set colSessions is also an object which connects to the sessions (same area you view via MMC) on the remote pc defined as session properties.  Primal Script is great, but its intuitve ness stops when it comes to WMI,ADO,CDO, and other com objects, but MSDN has all of it documented.  Also you may want to look at getting a WMI explorer, I am sure you can find one for free on the web.  I use the one that came with primal script.  It will allow you to surf all of the WMI possibilites and view their current values of you pc you are executing on This will give you insight on what you can do.  VBS is very powerful as you can see I can do things like creating and manipulating excel,word,dos prompts all to Active Directory and Computer management.  I know some people are saying power shell is the way to go but I stongly disagre as all I can see it as is a glorified Dos prompt, not to mention the syntax used in vbs is the same in VB so knoiw you can pickup on 2 languages.  I am 100% self taught in scripting.  Things that I have found very useful is 1.  Get a good understanind of "Object Oriented Programming" 2.  Look at Microsofts Scripting Guy they are very good and explain to good detail why you are doing what you are. 3. When wanting to do something in Excel/Word record a macro and look at it.  It is pretty much cut and paste into your script with some minor adjustments.  I hope these suggestions help.  I will give you a road map on my scripts.  Anything that starts with an o is an object, s is a string , i is an interger, a is an array, and col is a collection (also an object).
0
 

Author Comment

by:Dabosa
ID: 24326659
Thanks for all your work and  comments so far you've been more than helpful!

Thanks /D
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24327840
The time is in seconds I will setup to do dd:hh:mm:ss
0
 
LVL 6

Accepted Solution

by:
Mark Pavlak earned 500 total points
ID: 24329597
Here it is I hope this is what you want.  I figured if you want to actually save the file you can use the file...Sav As command in excel this way you have more flexability
'==========================================================================
'
' VBScript Source File -- Created with SAPIEN Technologies PrimalScript 2007
'
' NAME: OPen_Sessions_To_CSV
'
' AUTHOR: John Finner , GWFH
' DATE  : 5/6/2009
'
' COMMENT: 
'
'==========================================================================
'Global Variables
'=============================================================================================
On Error Resume Next
Dim oConnection,oExcel,oRange
Dim sComputerName
Dim iRow : iRow = 2
'=============================================================================================
'Constants for Excel Formatting
'=============================================================================================
Const xlCenter = -4108
Const xlBottom = -4107
Const xlContext = -5002
Const xlRight = -4152
'=============================================================================================
 
'Input box for Server Name
'=============================================================================================
sComputerName  = InputBox ("Please enter FQDN of Machine to be scanned","Get Open Sessions")
'=============================================================================================
'Connect to WMI on remote machine
'=============================================================================================
Set oConnection = GetObject("WinNT://" &sComputerName& "/LanmanServer")
Set colSessions = oConnection.Sessions
'=============================================================================================
'Initialize Excel and Format Header row
'=============================================================================================
Set oExcel = CreateObject("Excel.Application")
With oExcel
	.Visible = True
	.Workbooks.add()
	.Cells(1,1).value = "User"
	.Cells(1,2).value = "Computer"
	.Cells(1,3).value = "Connected Time (dd:hh:mm:ss)"
	.Cells(1,4).value = "Idle Time (dd:hh:mm:ss)"
	End With
'=============================================================================================
'Populate Spread sheet using iRow as the control
'=============================================================================================
For Each oSession in colSessions
	With oExcel 
	      .Cells(iRow,1).value = oSession.User
	      .Cells(iRow,2).value = oSession.Computer
	      .Cells(iRow,3).value = SecondsToText(oSession.ConnectTime)
	      .Cells(iRow,4).value = SecondsToText(oSession.IdleTime)
	End With
	iRow = iRow + 1
Next
'=============================================================================================
'Finalize and Save Spreadsheet
'=============================================================================================
	 'Right Align Time columns
	 '=================================================================================
	  	Set oRange = oExcel.Range("C:D")
	  	With oRange 
	  		.HorizontalAlignment = xlRight
       	    .VerticalAlignment = xlBottom
        	.WrapText = False
        	.Orientation = 0
        	.AddIndent = False
        	.IndentLevel = 0
        	.ShrinkToFit = False
        	.ReadingOrder = xlContext
        	.MergeCells = False
	  	End With
	 '=================================================================================
	'Format Header Row
	'=================================================================================
	  Set oRange = oExcel.Range("A1:D1")
	  oRange.Font.Bold = True
	  With oRange
		.HorizontalAlignment = xlCenter
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
	  End With
	 
	'=================================================================================
	'Autofit Page
	'=================================================================================
	 Set oRange =  oExcel.Range("A:D")
	 oRange.EntireRow.Autofit()
	 oRange.EntireColumn.Autofit()
	'=================================================================================
 
'=============================================================================================
Function GetEnvirmomentVariable(tmp)
Dim  objShell
Set objShell = CreateObject("WScript.Shell")
GetEnvirmomentVariable = objShell.ExpandEnvironmentStrings(tmp)
End Function
Function SecondsToText(Seconds) 
'This function was modified
'Orginial Source can be found
'http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=510866&Zf=f48&Zw=hours%20minutes&Zg=0&Zl=a&Main=510866&Search=true&where=&Zu=&Zd=l&Zn=&Zt=1&Zs=a&Zy=
Dim bAddComma 
Dim Result 
Dim sTemp 
If Seconds <= 0 Or Not IsNumeric(Seconds) Then 
SecondsToText = "0 seconds"
Exit Function
End If
Seconds = Fix(Seconds)
If Seconds >= 86400 Then
days = Fix(Seconds / 86400)
Else
days = 0
End If
If Seconds - (days * 86400) >= 3600 Then
hours = Fix((Seconds - (days * 86400)) / 3600)
Else
hours = 0
End If
If Seconds - (hours * 3600) - (days * 86400) >= 60 Then
minutes = Fix((Seconds - (hours * 3600) - (days * 86400)) / 60)
Else
minutes = 0
End If
Seconds = Seconds - (minutes * 60) - (hours * 3600) - _
(days * 86400)
If Seconds > 0 Then Result = Seconds & " " 
If minutes > 0 Then
bAddComma = Result <> ""
sTemp = minutes & "" 
If bAddComma Then sTemp = sTemp & ":"
Result = sTemp & Result
End If
If hours > 0 Then
bAddComma = Result <> ""
sTemp = hours & "" 
If bAddComma Then sTemp = sTemp & ":"
Result = sTemp & Result
End If
If days > 0 Then
bAddComma = Result <> ""
sTemp = days & "" 
If bAddComma Then sTemp = sTemp & ":"
Result = sTemp & Result
End If
SecondsToText = Result
End Function	
 
 
 
'' SIG '' Begin signature block
'' SIG '' MIIJxAYJKoZIhvcNAQcCoIIJtTCCCbECAQExCzAJBgUr
'' SIG '' DgMCGgUAMGcGCisGAQQBgjcCAQSgWTBXMDIGCisGAQQB
'' SIG '' gjcCAR4wJAIBAQQQTvApFpkntU2P5azhDxfrqwIBAAIB
'' SIG '' AAIBAAIBAAIBADAhMAkGBSsOAwIaBQAEFBxi2wQu0FR1
'' SIG '' tm0OAtZNmk8UluI+oIIHLjCCA04wggK3oAMCAQICAQow
'' SIG '' DQYJKoZIhvcNAQEFBQAwgc4xCzAJBgNVBAYTAlpBMRUw
'' SIG '' EwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNh
'' SIG '' cGUgVG93bjEdMBsGA1UEChMUVGhhd3RlIENvbnN1bHRp
'' SIG '' bmcgY2MxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2Vy
'' SIG '' dmljZXMgRGl2aXNpb24xITAfBgNVBAMTGFRoYXd0ZSBQ
'' SIG '' cmVtaXVtIFNlcnZlciBDQTEoMCYGCSqGSIb3DQEJARYZ
'' SIG '' cHJlbWl1bS1zZXJ2ZXJAdGhhd3RlLmNvbTAeFw0wMzA4
'' SIG '' MDYwMDAwMDBaFw0xMzA4MDUyMzU5NTlaMFUxCzAJBgNV
'' SIG '' BAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGlu
'' SIG '' ZyAoUHR5KSBMdGQuMR8wHQYDVQQDExZUaGF3dGUgQ29k
'' SIG '' ZSBTaWduaW5nIENBMIGfMA0GCSqGSIb3DQEBAQUAA4GN
'' SIG '' ADCBiQKBgQDGuLknYK8L45FpZdt+je2R5qrxvtXt/m3U
'' SIG '' LH/RcHf7JplXtN0/MLjcIepojYGS/C5LkTWEIPLaSrq0
'' SIG '' /ObaiPIgxSGSCUeVoAkcpnm+sUwd/PGKblTSaaHxTJM6
'' SIG '' Qf591GR7Y0X3YGAdMR2k6dMPi/tuJiSzqP/l5ZDUtMLc
'' SIG '' UGCuWQIDAQABo4GzMIGwMBIGA1UdEwEB/wQIMAYBAf8C
'' SIG '' AQAwQAYDVR0fBDkwNzA1oDOgMYYvaHR0cDovL2NybC50
'' SIG '' aGF3dGUuY29tL1RoYXd0ZVByZW1pdW1TZXJ2ZXJDQS5j
'' SIG '' cmwwHQYDVR0lBBYwFAYIKwYBBQUHAwIGCCsGAQUFBwMD
'' SIG '' MA4GA1UdDwEB/wQEAwIBBjApBgNVHREEIjAgpB4wHDEa
'' SIG '' MBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xNDQwDQYJKoZI
'' SIG '' hvcNAQEFBQADgYEAdrKc7hOfG/YtNJKURXM03I5rLlz8
'' SIG '' TH2J68No8deZDy4dF8i1Fou+zYoFBvIZSToDWwXJII5t
'' SIG '' UuF2gaDDZYoiZ+QcU1M3Rr+81y/re57QFEVsQCEI4l11
'' SIG '' dmYwHvTfgoovvfOiDL8d258UoppyN02wd0joSj8JzlUZ
'' SIG '' LO/mByThr+wwggPYMIIDQaADAgECAhB85OxeaEhr//bp
'' SIG '' 99NY8m8pMA0GCSqGSIb3DQEBBQUAMFUxCzAJBgNVBAYT
'' SIG '' AlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAo
'' SIG '' UHR5KSBMdGQuMR8wHQYDVQQDExZUaGF3dGUgQ29kZSBT
'' SIG '' aWduaW5nIENBMB4XDTA4MDYwNTAwMDAwMFoXDTA5MDUz
'' SIG '' MDIzNTk1OVowgaAxCzAJBgNVBAYTAlVTMRcwFQYDVQQI
'' SIG '' Ew5Ob3J0aCBDYXJvbGluYTEXMBUGA1UEBxMORWxpemFi
'' SIG '' ZXRoIENpdHkxKDAmBgNVBAoTH0dhdGV3YXkgRmluYW5j
'' SIG '' aWFsIEhvbGRpbmdzIEluYy4xCzAJBgNVBAsTAklUMSgw
'' SIG '' JgYDVQQDEx9HYXRld2F5IEZpbmFuY2lhbCBIb2xkaW5n
'' SIG '' cyBJbmMuMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB
'' SIG '' CgKCAQEA1asfrPULdZzPm7QfWBbbg+QXqtJBXAe2BDne
'' SIG '' tIBRGkTKPXqiruEvC4gahuHiLXWRFviusVNCMynbbDLo
'' SIG '' /UzUKflSXJIabAknmCYBPEgn7j9O6xhdWRPNb11TV2Wu
'' SIG '' rR9+EuiZ1EXNMmtKqMrtJEtoqe+Bsu//mQuhCjsHhMne
'' SIG '' mvXs6P5/F+YqcAlAwsQgOnqmMo/KbHZ/rPYrI6fB7zMq
'' SIG '' thWo6fdhMG0y6XKkvGxhB9MsmwVSSm0H66H7l04N15MS
'' SIG '' EJLDuUeF9KJATZ1b7MTayXOgnO+jbs8GiiS3aG0YJfHB
'' SIG '' 4EjuaLyyZ3zrrI/fvcoVMMaXrVMwLdFj9Q4lToI01wID
'' SIG '' AQABo4HYMIHVMAwGA1UdEwEB/wQCMAAwPgYDVR0fBDcw
'' SIG '' NTAzoDGgL4YtaHR0cDovL2NybC50aGF3dGUuY29tL1Ro
'' SIG '' YXd0ZUNvZGVTaWduaW5nQ0EuY3JsMB8GA1UdJQQYMBYG
'' SIG '' CCsGAQUFBwMDBgorBgEEAYI3AgEWMB0GA1UdBAQWMBQw
'' SIG '' DjAMBgorBgEEAYI3AgEWAwIHgDAyBggrBgEFBQcBAQQm
'' SIG '' MCQwIgYIKwYBBQUHMAGGFmh0dHA6Ly9vY3NwLnRoYXd0
'' SIG '' ZS5jb20wEQYJYIZIAYb4QgEBBAQDAgQQMA0GCSqGSIb3
'' SIG '' DQEBBQUAA4GBAHZiwWiiv64tSVDSiryF/MMP18u+Yzo6
'' SIG '' OkswDfk/dlCXOnp8HDGyNafT9ABsDfJziBD4ror0mXxi
'' SIG '' 0HzqG6NB2yKm3CWMXaZVYJmtKz2bs9NrQOJDfEEuPTwS
'' SIG '' 3TegCxFk5OLdIlQmwevsf92b3dZRIpAuxDNDnVKXmg9F
'' SIG '' ySSEG6XLMYICAjCCAf4CAQEwaTBVMQswCQYDVQQGEwJa
'' SIG '' QTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0
'' SIG '' eSkgTHRkLjEfMB0GA1UEAxMWVGhhd3RlIENvZGUgU2ln
'' SIG '' bmluZyBDQQIQfOTsXmhIa//26ffTWPJvKTAJBgUrDgMC
'' SIG '' GgUAoHAwEAYKKwYBBAGCNwIBDDECMAAwGQYJKoZIhvcN
'' SIG '' AQkDMQwGCisGAQQBgjcCAQQwHAYKKwYBBAGCNwIBCzEO
'' SIG '' MAwGCisGAQQBgjcCARYwIwYJKoZIhvcNAQkEMRYEFNut
'' SIG '' nOOcEWTWIuTs7PMpUqoWUvvPMA0GCSqGSIb3DQEBAQUA
'' SIG '' BIIBAJQ5Egkh5vguqX7UvjZZLdFBT7lUx5O8sY26aVDr
'' SIG '' RTBJMqC6cOXfqkDaGpxC9avRPrpZ5XLBE3y39560+SMB
'' SIG '' gVbWEOGxdADPqpw03EWWV8RwDdFqYyKct796rzFhtuqE
'' SIG '' 8HKeKKSah8B28e02zxLcmlRg6Is8egOOh1kUSChZHLVb
'' SIG '' xXOAzu7CLoL7pDmh7hvelc0+0zNiMp1Mb2j0zeR9GKLN
'' SIG '' iVTSERjWaf+ACgMp4nKX8fUynssWUk2+mDcviJraUTUr
'' SIG '' oynvV0k+ziuRyiUgH3qxQLW5sUDMXGoGxy9XC5TYElDS
'' SIG '' be9C3ra/JpuL/v9lkMRRn9dua37UHcsuuzIKGLU=
'' SIG '' End signature block

Open in new window

0
 

Author Closing Comment

by:Dabosa
ID: 31578443
Thank you! if you get a change to give that roadmap to what you've done, be more than greatful!  btw that huge code for SIG whet is that? /D
0
 
LVL 6

Expert Comment

by:Mark Pavlak
ID: 24335257
I have a code signing cert since I write/approve all code that is executed in my domain.  Primal Script automatically signs everything I wrie You may want to remove that section as that cert expires on the 30th of May.  But if you were to save the script and right click it and select porperties and look at the signatures tab.  I am slammed this weekend I will try to sit down monday and try to get you a road map on this.  Glad it worked for you.
0

Featured Post

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question