ITNinja

Below is what I use for a Scripting 'Run Now Status' report if helps at all.

Select Distinct
M.NAME, M.IP, M.USER_LOGGED, KM.REQUEST_TIME, KM.KBOT_LOG_ID, KB.NAME AS Script
From
MACHINE M
Left Join KBOT_RUN_MACHINE KM On M.ID = KM.MACHINE_ID
Left Join KBOT_RUN K On K.ID = KM.KBOT_RUN_ID
Left Join KBOT KB On KB.ID = K.KBOT_ID
Where
KM.KBOT_LOG_ID IS NOT NULL
AND KM.REQUEST_TIME > DATE_SUB(NOW(), INTERVAL 30 DAY)
Order By KM.KBOT_LOG_ID, M.NAME - bnerison 10 years ago

This is where I'd start:
SELECT * FROM ORG1.KBOT_LOG
WHERE KBOT_ID = 581
and DATE(START_TIME) = DATE(NOW())

This will get you the log entries for script ID 581 that ran today. The status is recorded as a number so you'd need to check and see what those equate to for your scripts. - chucksteel 10 years ago

Still just looking for a report listing Kscript(s) I created and ran on a schedule. Example is a script I created to remove Java 6u31 from group of machines. I have to look at each machine details to see if ran and was successful or not. Would be nice to have a column list of the script(s), machine name, and if pass or fail...thanks! - bnerison 10 years ago

Here are the column items needed in the CSV report: K-script name, system name, login user, IP, some type of scripting log status (i.e. pass or fail) and a timeline (i.e. ran within last x-days or other). The report wizard is worthless for this as I have spent days trying to get the results...:( - bnerison 10 years ago

good day

did you get any luck with this issue bnerison

i take it that you looking for a report to display the success and failures when running it via a script?

i might have a solution for you - burtono 10 years ago

This is what worked for me

Upload your software as a manage install and upload it as a dependency
after is has been uploaded create a manage install but the (MANAGED ACTION should be DISABLED and add all the labels you are targetting or machines and then save.

Run your script targetting the labels or machines that you needed just like you have added it to the manage install

Under the reporting tab copy this script below and then editing the report just add the name of the software WHERE DISPLAY_NAME = 'Name of software'

and WALLA!!! the report should present the name, software installed and not installed via csv




SELECT DISTINCT DATE_FORMAT(MI.CREATED,'%Y/%m/%d') as CREATED_DATE,
S.DISPLAY_NAME,
S.DISPLAY_VERSION,

CASE
WHEN MS.MACHINE_ID > 0 THEN 'Installed'
WHEN MIA.ATTEMPT_COUNT > 0 THEN CONCAT('Not Installed (',MIA.ATTEMPT_COUNT,' of ', MI.MAX_ATTEMPT_COUNT,' attempts)')
ELSE 'Not Installed'
END AS STATUS,
M.NAME,
M.IP,
M.LAST_SYNC,
M.USER_NAME
FROM SOFTWARE S
JOIN MI
ON ( S.ID = MI.SOFTWARE_ID )
JOIN MI_LABEL_JT MIL
ON ( MI.ID = MIL.MI_ID )
JOIN LABEL L
ON ( MIL.LABEL_ID = L.ID )
JOIN MACHINE_LABEL_JT ML
ON ( L.ID = ML.LABEL_ID )
JOIN MACHINE M
ON ( ML.MACHINE_ID = M.ID )
JOIN SOFTWARE_OS_JT SO
ON ( SO.SOFTWARE_ID = S.ID
AND SO.OS_ID = M.OS_ID )
LEFT JOIN MACHINE_SOFTWARE_JT MS
ON ( M.ID = MS.MACHINE_ID
AND MS.SOFTWARE_ID = S.ID )
LEFT JOIN MI_ATTEMPT MIA
ON ( MIA.MI_ID = MI.ID
AND MIA.MACHINE_ID = M.ID )
WHERE DISPLAY_NAME = 'Name of software'
ORDER BY S.DISPLAY_NAME,
S.DISPLAY_VERSION,
STATUS

let me know if this helps....... :-) - burtono 10 years ago

I tried you suggestion but didn't work. Not sure how the managed install (MI) is tied into the k-script? Since I have to configure all the items related to and to complete the install from the script was in the need for a MI item? I'm still playing with this... - bnerison 10 years ago

hi bnerison

apologies for the late reply

What is it that is haunting you with the K1000?
with regards to deploying,scripting and reporting etc........ - burtono 10 years ago

Hi burtono, thanks for your help on this!
At this point our biggest issue is obtaining results when running a non-install script (by either using the run now or a scheduled one for later date). Here are some examples (WOL machines, copy a file over, remove old versions of Java, reboot PC's, run a command line to do whatever, run a non-install task, etc.). There are quite a few build-in non-install scripts on the Kace box and we create others but no way to report the run results if scheduled after hours. I would like to come in the next day and pull up the results of a script that I ran. There are some suggestion with in my post here however may not be working as noted. - bnerison 10 years ago

I am still looking for answers to this question... - bnerison 10 years ago