Scripts

[SRJaeger]

Are scripts stored the way copy file and software packages are?  If so, what would be the path on the server?

[Alex Hedley]

Do you mean a script as a Task?

Manage | Jobs & Tasks

New | Task

Run Script (on Server | on Task Server)

These are stored as State data in SQL.

SELECT [State] FROM vItem WHERE Guid = '###'

See

Table that stores the script for tasks?

https://www.symantec.com/connect/forums/table-stores-script-tasks

[SRJaeger]

Where do I find the GUID for the script? If I look at porperties of a script, there is a GUID, but that results in null--

Name:	2-Attachmate setup silent with transform
Description:	The quick software delivery task delivers the selected software resource
Product Name:	'Software Management Solution' (ad3f5980-d9e9-11d3-a318-0008c7a09198)
Folder:	\SMP 8.1 RU2\Tasks\Jobs and Tasks\_OIT Job & Tasks\Software\Attachmate\ATTACHMATE 16.1_MicroFocus\Not Working- save for reference
Attributes:	Normal
Creation Date:	Thursday, April 18, 2019, 11:32 AM
Modification Date:	Thursday, April 18, 2019, 12:23 PM
Last modified by:	OIT\OIXJAEG
Guid:	{f235a4b3-5edf-49f4-896a-2b1cc246bbc8

[Alex Hedley]

Can you try the extended sql from donald.noah.

 

declare @taskGuid uniqueidentifier

set @taskGuid = '3DBE32CB-9482-43BF-9ABC-DD056B771F85'

select top (1) iv.Version 'Version',
	iv.ItemGuid,
	ivd.name,
	ivd.Description,
	ivd.ModifiedBy,
	ivd.ModifiedDate,
	cast(ivd.state as nvarchar(max)) 'State'
from ItemVersions iv
left join ItemVersionData ivd
	on ivd.VersionGuid = iv.VersionGuid
where iv.ItemGuid = @taskGuid
group by iv.Version,
	iv.ItemGuid,
	ivd.name,
	ivd.Description,
	ivd.ModifiedBy,
	ivd.ModifiedDate,
	cast(ivd.state as nvarchar(max))
order by iv.Version desc

 

[Alex Hedley]

Useful sp from Igor Perevozchikov on Forum Post

EXECUTE spLoadItemByGuidAndVersion @itemGuid='Specify here GUID of your task', @Culture=N'en-US', @version=-1