Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

WinMSSQL.py issue with querying jobs containing domain name owners #195

Open
ericwebb opened this issue Jul 2, 2014 · 0 comments
Open

Comments

@ericwebb
Copy link

ericwebb commented Jul 2, 2014

Looks like when modeling, there is a query looking for the SQL jobs.

The user for my jobs is a domain\name, this breaks the code when parsing on the user info for the job.

ZenPacks / zenoss / Microsoft / Windows / modeler / plugins / zenoss / winrm / WinMSSQL.py

Get SQL Jobs information

jobsquery = "select s.name as jobname, s.job_id as jobid, "
"s.enabled as enabled, s.date_created as datecreated, "
"s.description as description, l.name as username from "
"msdb..sysjobs s left join master.sys.syslogins l on s.owner_sid = l.sid"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant