Solved

Find username with vbscript using server session's for query

Posted on 2009-05-06
29
1,328 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
  • 18
  • 11
29 Comments
 
LVL 6

Expert Comment

by:Mark Pavlak
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 6

Expert Comment

by:Mark Pavlak
Comment Utility
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
Comment Utility
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
Comment Utility
ok no problem,  sometimes I get a little overboard, Be ready in a bit
0
 
LVL 6

Expert Comment

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

Author Comment

by:Dabosa
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
ok thats good!! I would prefer the script to save it as jfinner.xls

Thanks /D
0
 
LVL 6

Expert Comment

by:Mark Pavlak
Comment Utility
ok
0
 
LVL 6

Expert Comment

by:Mark Pavlak
Comment Utility
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
Comment Utility
thats not important, nor is guests.
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 6

Expert Comment

by:Mark Pavlak
Comment Utility
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
Comment Utility
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
Comment Utility
very nice! only thing is to get the time in a readable format.

Excellent job!
0
 

Author Comment

by:Dabosa
Comment Utility
no wmi controls needed to install on server
0
 
LVL 6

Expert Comment

by:Mark Pavlak
Comment Utility
What do you mean by readable format?  
0
 

Author Comment

by:Dabosa
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

744 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now