Contents
-
Writing Tachyon Instructions
-
Getting started with TIMS
-
Installing TIMS
-
Running instructions in Tachyon for the first time
-
Instruction Definition Reference
-
SCALE User Guide
-
Functions and Methods Reference
-
Tachyon Agent Methods
-
Agent.CheckForUpdates
-
Agent.Echo
-
Agent.GetConnectionInformation
-
Agent.GetDiagnostics
-
Agent.GetExtensibility
-
Agent.GetInstructionStatistics
-
Agent.GetKeyFiles
-
Agent.GetSummary
-
Agent.Log
-
Agent.Sleep
-
Agent.Stagger
-
ContentDistribution.Stage
-
ContentDistribution.StageAndExecute
-
Device.GetCriticality
-
Device.GetDisks
-
Device.GetInboundMappedDriveHistory
-
Device.GetInboundPrinters
-
Device.GetLocation
-
Device.GetOutboundMappedDriveHistory
-
Device.GetOutboundPrinters
-
Device.GetProcessors
-
Device.GetSummary
-
Device.SetCriticality
-
Device.SetLocation
-
Discovery.LookupNetBiosNames
-
Discovery.ScanPortsOnDevices
-
Discovery.SendArpRequest
-
FileContent.AppendText
-
FileContent.FindAndAppend
-
FileContent.FindAndDelete
-
FileContent.FindAndReplace
-
FileContent.GetTorrentAnnounceUris (deprecated)
-
FileContent.GetTorrentDescribedFiles (deprecated)
-
FileContent.GetTorrentInfo (deprecated)
-
FileContent.WriteText
-
FileSystem.CreateTempFile
-
FileSystem.DeleteFileByName
-
FileSystem.FindDirectoryByName
-
FileSystem.FindFileByName
-
FileSystem.FindFileBySizeAndHash
-
FileSystem.GetDigitalSignature
-
FileSystem.GetDirectoryHash
-
FileSystem.GetFile
-
FileSystem.GetFileByLine
-
FileSystem.GetFileDetails
-
FileSystem.GetFileHash
-
FileSystem.GetFilePermissions
-
FileSystem.GetFilesInDirectory
-
FileSystem.GetFilesInFolder (deprecated)
-
FileSystem.GetHash (deprecated)
-
FileSystem.GetVersionInfo
-
FileSystem.PathExists
-
Http.Post
-
Interaction.GetActiveResponses
-
Interaction.GetInteractionState
-
Interaction.GetResponseHistory
-
Interaction.GetSessions
-
Interaction.GetWindows
-
Interaction.InvalidateResponse
-
Interaction.SetDoNotDisturb
-
Interaction.ShowAnnouncement
-
Interaction.ShowNotification
-
Interaction.ShowQuestion
-
Interaction.ShowSurvey
-
Inventory.GetTables
-
Method Notes
-
Mobile.GetEmailAddress
-
Mobile.GetEncryptionStatus
-
Mobile.GetLocation
-
Mobile.GetMobileSummary
-
Mobile.GetPasswordQuality
-
Mobile.IsGPSEnabled
-
Mobile.IsPrintingSupported
-
NativeServices.GetWmiNames
-
NativeServices.RegistryDeleteKey
-
NativeServices.RegistryDeleteUserKey
-
NativeServices.RegistryDeleteUserValues
-
NativeServices.RegistryDeleteValue
-
NativeServices.RegistryEnumerateKeys
-
NativeServices.RegistryEnumerateUserKeys
-
NativeServices.RegistryEnumerateUserValues
-
NativeServices.RegistryEnumerateValues
-
NativeServices.RegistryGetUserValues
-
NativeServices.RegistryGetValue
-
NativeServices.RegistryKeyExists
-
NativeServices.RegistrySetUserValues
-
NativeServices.RegistrySetValue
-
NativeServices.RegistryUserKeyExists
-
NativeServices.RegistryUserValueExists
-
NativeServices.RegistryValueExists
-
NativeServices.RunCommand
-
NativeServices.RunWmiInstanceMethod
-
NativeServices.RunWmiQuery
-
NativeServices.RunWmiStaticMethod
-
Network.GetArpEntries
-
Network.GetConnections
-
Network.GetDnsEntriesByAddress
-
Network.GetIpAddress (deprecated)
-
Network.GetIpAddresses
-
Network.GetListeningEndpoints
-
Network.GetNetworkSummary
-
Network.GetWiFiNetworks
-
Network.SetAirplaneMode
-
Network.SetBlueToothMode
-
Network.SetWiFiMode
-
Nomad.CachedPkgStatus
-
Nomad.FindBestPkgCache
-
Nomad.GetCachedPkgDetails
-
Nomad.GetCmContentLocations
-
Nomad.GetVariable
-
Nomad.JobsStatus
-
Nomad.Pause
-
Nomad.PauseJobQueue
-
Nomad.Resume
-
Nomad.ResumeJobQueue
-
Nomad.RunPkgStatusRequest
-
Nomad.RunSsdQuery
-
Nomad.Status
-
Nomad.Stop
-
OperatingSystem.ControlService
-
OperatingSystem.GetInstalledUpdates
-
OperatingSystem.GetProcesses
-
OperatingSystem.GetRunningApps
-
OperatingSystem.GetServiceInfo
-
OperatingSystem.GetSummary
-
OperatingSystem.GetUpdatesPendingReboot
-
OperatingSystem.GetUpdateSummary
-
OperatingSystem.KillProcess
-
OperatingSystem.KillProcesses
-
Patch.Deploy
-
Patch.GetStatus
-
Patch.List
-
Patch.TestConnection
-
Policy.ForceStatusReport
-
Policy.GetEventSubscriptions
-
Policy.GetRuleEvaluationHistory
-
Policy.GetRules
-
Policy.GetStatistics
-
Policy.GetSummary
-
Policy.Invalidate
-
Scripting.Run
-
Scripting.RunText
-
Security.CheckSimpleIoc (deprecated)
-
Security.DeleteCertificates
-
Security.GetCertificates
-
Security.GetQuarantineStatus
-
Security.ModifyQuarantineWhitelist
-
Security.QuarantineDevice
-
Security.UnquarantineDevice
-
Software.GetInstallations
-
Software.GetUserInstallations
-
Software.Uninstall
-
Storage.Check
-
Storage.Delete
-
Storage.Get
-
Storage.GetRemote
-
Storage.List
-
Storage.Set
-
Tagging.Check
-
Tagging.Clear
-
Tagging.Count
-
Tagging.Delete
-
Tagging.Get
-
Tagging.GetAll
-
Tagging.Set
-
Users.FindLocalGroupMember
-
Users.GetInboundConnectionHistory
-
Users.GetLocalGroupMembers
-
Users.GetLoggedOnUsers
-
Users.GetOutboundConnectionHistory
-
Users.GetPrimaryUser
-
Utilities.GenerateSequence
-
Utilities.JsonFromTable
-
Utilities.SplitLines
-
Utilities.TableFromJson
-
Agent.CheckForUpdates
-
Tachyon Agent Built-in Functions
-
Tachyon Agent Built-in Keywords
-
Tachyon Agent SQL Functions
-
Tachyon Agent Methods
-
Custom Response Visualizations
-
Training Lab Guide - Advanced
-
Getting started with TIMS
-
Integrating with Tachyon
-
Tachyon .NET Consumer SDK
-
Tachyon PowerShell Toolkit
-
Index
Method | SplitLines |
---|---|
Module | Utilities |
Library | Core |
Action | Convert a delimited fragment of text into multiple rows. |
Parameters |
|
Return values | For each occurrence of
|
Example | Take a string in CSV format and split that string into multiple rows based on a comma delimiter: @c = SELECT "Red,Yellow,Blue,Black,White,Green" AS Colors; @c = Utilities.SplitLines(Text: @c.Colors, Delimiter: ","); |
Platforms |
|
Notes | The If you omit the Line numbers are not returned, therefore you must use the built-in SQLite autoincremented key rowid if you need to perform operations on the Output. For example the below code will return the last inserted row "Green" whereas max(Output) would return "Yellow". select Output from @c order by rowid desc limit 1; |