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 Report showing only Wi-Fi Devices and MAC addresses
by  Andy.S   Go to last post Go to first unread
Last post: Today at 2:23:24 PM(UTC)
Lansweeper Modifying Purchase Date / Yearly Refresh Report
by  Cripple.Zero   Go to last post Go to first unread
Last post: 5/7/2021 7:06:47 PM(UTC)
Lansweeper Tweak LanSweepers Bios Version Audit to show Last Seen
by  Tyler M.  
Go to last post Go to first unread
Last post: 5/6/2021 8:22:40 PM(UTC)
Lansweeper Patch Volume Across Fleet
by  darren.kimber  
Go to last post Go to first unread
Last post: 5/5/2021 11:29:33 PM(UTC)
Lansweeper Show Date Without Time
by  nhouse24   Go to last post Go to first unread
Last post: 5/4/2021 10:39:43 PM(UTC)
Lansweeper Report of list of assets
by  Carlos Montes  
Go to last post Go to first unread
Last post: 5/4/2021 2:52:15 PM(UTC)