Notification

Icon
Error

Passing parameters from Widget to dB

Posted: Wednesday, April 24, 2013 12:01:56 PM(UTC)
Raviraj

Raviraj

Member Original PosterPosts: 7
0
Like
Hello team,

I want to create a widget in which user's input is passed as a parameter to a Query in tsysDBObjects. I looked through the tester sample widget, but how do I send the testinput value as parameter to Query?
Just For eg, suppose i want to execute web50softwarescreen with user entering assetID and then display the table below, How do i do that.
Please Help me with this. thanks!
Lansweeper
#1Lansweeper Member Posts: 13,442  
posted: 4/26/2013 5:02:27 PM(UTC)
It would be easier to just run the report below and filter the AssetName column within the report results.
Quote:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblSoftwareUni.Approved,
tblSoftware.Installdate,
tsysOS.Image As icon
From tblSoftwareUni
Inner Join tblSoftware On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Order By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
DTCLARK
#2DTCLARK Member Posts: 11  
posted: 3/8/2017 10:36:23 PM(UTC)
That's not an answer....

In our case we want to be able to allow users (Non-Admins of Lansweeper) to force a scan of an individual IP Address. Unfortunately the security of Lansweeper is nowhere near granular enough to allow that. So a widget that would allow a Non-Admin level user to enter in an IP of a newly added system (Printer, Linux Machine, Standalone Server whatever) would be extremely useful... We have over 800 Subnets and they are only scanned once a week, so having to wait up to (possibly) a week for a system to appear is a huge drain on resources.

Bonus points if it could verify that the IP Being entered was within a scanning range...


Dave

Active Discussions

Lansweeper End of Life Asset Report
by  Hendrik.VE   Go to last post Go to first unread
Last post: Today at 2:18:23 PM(UTC)
Lansweeper Translation settings not saved
by  Brandon  
Go to last post Go to first unread
Last post: Yesterday at 2:10:22 PM(UTC)
Lansweeper Combobox translation
by  sneagele   Go to last post Go to first unread
Last post: Yesterday at 2:03:45 PM(UTC)
Lansweeper Freelance for Lansweeper Deploy?
by  Brandon  
Go to last post Go to first unread
Last post: 5/7/2021 6:32:21 PM(UTC)
Lansweeper Installation issues
by  Richie_Rich   Go to last post Go to first unread
Last post: 5/6/2021 11:29:09 PM(UTC)
Lansweeper Cloud relay data stored time
by  Richie_Rich  
Go to last post Go to first unread
Last post: 5/6/2021 11:14:42 PM(UTC)
Lansweeper Custom attributes from AD
by  dhoward   Go to last post Go to first unread
Last post: 5/6/2021 11:10:45 PM(UTC)
Lansweeper User View Customization
by  DarkOne77  
Go to last post Go to first unread
Last post: 5/6/2021 10:50:30 PM(UTC)