Notification

Icon
Error

SQL Triggers - Are SQL triggers possible to implement in LS?

Posted: Saturday, March 28, 2020 9:43:26 PM(UTC)
Kyle Zimmerman

Kyle Zimmerman

Member Original PosterPosts: 2
0
Like
Hi all,

I am an intern and I am tasked with a couple projects that involve Lansweeper. I was wondering if it is possible to set up a SQL trigger in Lansweeper's database? What I am currently trying to do is when a ticket is duplicated I want a SQL trigger to copy that data stored in the htblhistory table and store that information in a different table. Is something like this possible in Lansweeper? If so how would I accomplish that?

Thanks,
Kyle Zimmerman
RKCar
#1RKCar Member Posts: 82  
posted: 3/30/2020 12:46:50 PM(UTC)
This is more of a SQL question than it is a Lansweeper question.

This can likely be accomplished via some sort of stored procedure if you determine what occurs in the SQL database when a ticket is duplicated and base the procedure off of that. Not really my forte so my guidance is limited to that.
Kyle Zimmerman
#2Kyle Zimmerman Member Original PosterPosts: 2  
posted: 4/3/2020 4:44:55 PM(UTC)
Okay, thank you.

I guess the main issue that I am facing right now is I don't know how to edit the Lansweeper database outside of Reports and the DatabaseMaintenance tool. In both of these I can not preform certain SQL commands such as CREATE TRIGGER. What must I do to be able to add that stored procedure to the database?

Thank you for the help,
Kyle
RKCar
#3RKCar Member Posts: 82  
posted: 4/6/2020 2:32:36 PM(UTC)
Being that it sounds like you aren't familiar with SQL, I would hesitate in making changes. At a minimum, make sure you have a backup of the database. You mentioned that you are an intern, so you don't want to get in over your head and break the entire environment in an attempt to accomplish this task.

If your installation is using a separate, full version of SQL, you would use SQL Server Management Studio. I'm not sure what your options are for the current "Lansweeeper provided" database.

Active Discussions

Lansweeper Unable to send to External Email
by  pryan67   Go to last post Go to first unread
Last post: Yesterday at 8:21:01 PM(UTC)
Lansweeper Lansweeper assets not being Scanned
by  Jordan  
Go to last post Go to first unread
Last post: Yesterday at 6:42:22 PM(UTC)
Lansweeper Database size growing too large
by  bladd   Go to last post Go to first unread
Last post: Yesterday at 4:26:44 PM(UTC)
Lansweeper Searching Specific File
by  mzipperer  
Go to last post Go to first unread
Last post: Yesterday at 4:23:29 PM(UTC)
Lansweeper Exchange 2010 information is not populating
by  Moe   Go to last post Go to first unread
Last post: Yesterday at 12:30:38 PM(UTC)
Lansweeper Routinely Exploited Vulnerabilities Query Report
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 12:25:31 PM(UTC)
Lansweeper Creating a report for new devices every 2 hours to alert
by  Moe   Go to last post Go to first unread
Last post: 6/4/2020 7:26:11 PM(UTC)
Lansweeper Changes in the licensing model
by  BullGates  
Go to last post Go to first unread
Last post: 6/4/2020 6:27:23 PM(UTC)