Aug 31, 2021
01:52 PM
I spoke too soon. We still have a few active records that we are not able to delete/un-link. See attached screenshot of the records.
... View more
Aug 31, 2021
01:27 PM
That works. Is there a way to delete/unlink non-active devices from this view without deleting the asset record?
... View more
Aug 31, 2021
12:16 PM
The asset was marked as "retired" in 2019 and changed to "In Storage" in Nov, 2020. Is there a possible issue that we need to address? Is there and SQL script that can easily show devices/assets that are incorrect? Is it correct the Asset is in ComplianceComputer without inventory or discovery records? Thank you for your help on this?
... View more
Aug 31, 2021
11:24 AM
We are running FNMS Product version: FlexNet Manager Suite 2020 R2 Release number: 16.0.1.3 From the screenshot, you can see it says the device was deleted but it remains. If I go to the inventory screen, the device does not exist but does exist as an asset.
... View more
Aug 31, 2021
08:55 AM
Maybe I don't understand the structure of the clustered VMWare tables but we want to be able to remove/delete items. One item in question, is visible in ComplianceComputer_MT, but is only in asset and not in inventory. How can we get rid of these unclustered items?
... View more
Aug 30, 2021
01:27 PM
Interesting. The device is not in our ALL inventory, only in asset and in Unclustered hosts and VMs. We probably had the item deleted from inventory since was so old. Now it only appears in Unclustered hosts and VMs view.
... View more
Aug 30, 2021
01:02 PM
@kclausen We are trying to remove an old device. The device is not in inventory, only in Virtual Devices and Clusters. How do we remove/delete this device.
... View more
Aug 30, 2021
10:19 AM
1 Kudo
We are trying to delete "Unclustered hosts and VMs" from "Virtual Devices and Clusters". We check the check box of item to delete, click on delete button, confirm the " Are you sure you want to delete this item?" pop-up window, and the systems says " The item is deleted successfully." Problem is that the item is not deleted and no error is displayed. Are we doing something incorrect?
... View more
Aug 20, 2021
07:13 AM
Does deleting from ComplianceHistory also delete from ComplianceHistory_MT and ComplianceHistoryLimited_MT? We have much older data (3 years older) in ComplianceHistoryLimited_MT than ComplianceHistory_MT so I was wondering if there are database triggers on the ComplianceHistory View to clean both tables or should we run two scripts to clean the tables separately? Thank you
... View more
Aug 19, 2021
08:51 AM
Hello, We are using SCCM/MECM for our deployment technology. I am guessing that the manual operation would not succeed since the request never gets created due to the the issues I mentioned. Without a request, there is no request/order number.
... View more
Aug 13, 2021
09:16 AM
The documentation states that for best performance we should have no more than 10,000 devices per beacon. Does this depend on beacon hardware or purely network related? For example. If beacon is running with two Xeon processors at 2.6 GHz, would that be able to process more than 10,000 devices? From documentation: (https://docs.flexera.com/flexera/EN/ITAssets/NumberOfInvBeacons.htm) For good performance, limit each beacon to about 10,000 devices that it will inventory directly or through the installed Inventory Agent. (This limit does not apply to inventory collected from third-party systems.) Manage this load by assigning individual subnets to each inventory beacon through the settings in the compliance browser.
... View more
Labels
- Labels:
-
agent
-
beacon
-
Inventory Gathering & Data
Aug 12, 2021
03:50 PM
We have situations where a software request fails ServiceNow workflow validation due to a device not having the deployment client installed. The request was approved so they want the process for adding the user to the AD group configured for the requested item to still succeed since the user has been approved for use of that software catalog item. The software request will be fulfilled by manual workflow but, that workflow cannot request the user being added to the AD group. Is there an API call that can be called by a manual install workflow approval that would add the user of that request to the AD group associated with the manual request?
... View more
Aug 12, 2021
12:08 PM
3 Kudos
Jim, The process I use is working well for updating the meta column in ServiceNow from keywords in AppPortal. ServiceNow's meta column takes a coma delimited string so it was very easy to implement. I then create a JSON object of values I want to update in ServiceNow and pass to a pi/now/table/x_fls_appportal_import_service. Your sync process provided a great starting point for understanding how this worked. I first created a web service that can be called from PowerShell. The web service script is based on the web service created to synchronize catalog images but was modified to also get the keywords as well as custom variables we need to keep synchronized. This query gets all items that were updated in ServiceNow within the past 70 minutes. You could probably imbed the SQL into the PowerShell but I have other functions in the web service that I needed for other work. SELECT DISTINCT
pkgs.PackageTitle AS CatalogTitle,
stuff((SELECT ',' + WD_WebPackageKeyword.KeyWord FROM WD_WebPackageKeyword WHERE WD_WebPackageKeyword.PackageID_FK = pkgs.PackageID FOR XML PATH('')), 1, 1, '') AS [Keywords],
psnc.ServiceNowCatalogId AS ServiceNowCatalogId,
psnc.UpdatedOn, pkgs.PackageID AS AppPortalPackageID,
pkgs.[ImagePath]
FROM vSearchCatalog pkgs
JOIN [dbo].[WD_Package_SNCatalog] psnc ON psnc.[PackageID_fk] = pkgs.PackageID
WHERE
psnc.Info NOT IN ('Deleted')
AND DATEDIFF(MINUTE, psnc.[UpdatedOn], SYSDATETIME()) < 70
AND pkgs.PackageTitle NOT IN ('Template Freeware', 'Template Licensed'); The next step was to create a PowerShell script that calls web service and iterates through items that were updated in ServiceNow in past 60 minutes and create a JSON object that gets passed to ServiceNow REST API. # Iterate through the recently synced catalog items and upload their "Keywords" to the "meta" field.
ForEach ($CatalogItem in $UpdatedCatalogItems) {
Try {
#Build JSON object of vields to update in ServiceNow.
$json = new-object -TypeName PSObject
$json | Add-Member -Type NoteProperty -Name 'meta' -Value $($CatalogItem.keywords)
$json | Add-Member -Type NoteProperty -Name 'ap_packageid' -Value $($CatalogItem.AppPortalPackageID)
$bodyJson = $json | ConvertTo-Json
# Build result string
$result = "Update ServiceNow '$($CatalogItem.CatalogTitle)' (Updated in AppPortal on: $($CatalogItem.UpdatedOn)) (PackageID: $($CatalogItem.AppPortalPackageID)) meta='$($CatalogItem.keywords)'"
# Call function to update ServiceNow.
if ((UpdateSnCatalogField $($CatalogItem.ServiceNowCatalogId) $bodyJson)) {
$result += ": SUCCESS"
$updateCount += 1
} else {
$result += ": FAILED"
$failCount += 1
}
Log($result)
}
Catch [System.Exception] {
$errMsg = "EXCEPTION when calling UpdateSnCatalogField function... $($_.Exception) ServiceNowCatalogId: $($CatalogItem.ServiceNowCatalogId), Meta: $($CatalogItem.Keywords) "
LogError($errMsg)
}
} The function below would was called during the iteration of updated catalog items to call ServiceNow's REST API, api/now/table/x_fls_appportal_import_service function UpdateSnCatalogField([string]$snCatId, $bodyJson) {
# Change the Content-Type header to JSON
# Set headers for ServiceNow Attachment API call
$headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$headers.Add('Authorization', "Basic $SCRIPT:snAuth")
$headers.Add('Accept', 'application/json')
$headers.Add('Content-Type', 'application/json')
$method = "POST"
if ($GLOBAL:debugLogging) { Log ("BodyJson=($bodyJson)") }
# Send HTTP request
$response = Invoke-WebRequest -UseBasicParsing -Headers $headers -Method $method -Uri $SCRIPT:serviceNowAppPortalImportServiceURL -Body $bodyJson
# Check response status
if ($response.StatusCode -eq 201) {
#success
if ($GLOBAL:debugLogging) { Log ("Set $snFieldName value to ($snFieldValue) for catalog item ($snCatId)") }
}
else {
LogError("Failed to set $snFieldName value to ($snFieldValue) for catalog item ($snCatId): $($response.StatusCode) $($response.StatusDescription)")
return $false
}
return $true
} I scheduled this task to run every 60 minutes. We don't do any transformation on the ServiceNow 'meta' column as it appears to work fine with comma delimited list of keywords.
... View more
Aug 03, 2021
12:26 PM
I have unsuccessfully found anything in documentation but tried to uncheck "Global Options => Is enabled?" in hope it would update ServiceNow to make the catalog item not active. Did not impact item in ServiceNow so I was hoping there was an option, without archiving a catalog item, to mark an item inactive in ServiceNow. Any suggestions without manually going into ServiceNow to mark catalog items inactive?
... View more
Aug 03, 2021
09:52 AM
Hello Jim, The script I wrote is working well for updating the meta column in ServiceNow from keywords in FNMS. ServiceNow's meta column takes a coma delimited string so it was very easy to implement. I then create a JSON object of values I want to update in ServiceNow and pass to a pi/now/table/x_fls_appportal_import_service. Your icon sync process provided a great starting point for understanding how this worked. Example: SELECT pkgs . PackageID , pkgs . PackageTitle , stuff (( SELECT ',' + wpk . KeyWord FROM WD_WebPackageKeyword wpk WHERE wpk . PackageID_FK = pkgs . PackageID FOR XML PATH ( '' )), 1 , 1 , '' ) AS [Keywords] FROM vSearchCatalog pkgs WHERE pkgs . PackageID BETWEEN 100 AND 110
... View more
Latest posts by kevin_christens
Subject | Views | Posted |
---|---|---|
421 | Oct 28, 2022 02:39 PM | |
140 | Oct 11, 2022 02:41 PM | |
223 | Oct 10, 2022 01:15 PM | |
348 | Sep 26, 2022 01:33 PM | |
200 | Sep 19, 2022 04:31 PM | |
259 | Sep 06, 2022 08:35 AM | |
365 | Aug 24, 2022 01:37 PM | |
686 | Aug 11, 2022 08:25 AM | |
728 | Aug 10, 2022 02:25 PM | |
738 | Aug 10, 2022 02:02 PM |
Activity Feed
- Posted Either refresh agent beacon list or remove old beacons from config.ini and registries? on FlexNet Manager Forum. Oct 28, 2022 02:39 PM
- Posted Why would not all supported self-update platforms not update the agent even when we are getting current inventory? on FlexNet Manager Forum. Oct 11, 2022 02:41 PM
- Posted Re: Limit bandwidth taken by self-upgrade of agents on FlexNet Manager Forum. Oct 10, 2022 01:15 PM
- Posted Limit bandwidth taken by self-upgrade of agents on FlexNet Manager Forum. Sep 26, 2022 01:33 PM
- Kudoed Re: Are there plans to support auto-upgrade of inventory agent on Ubuntu servers? for tjohnson1. Sep 20, 2022 06:09 AM
- Posted Are there plans to support auto-upgrade of inventory agent on Ubuntu servers? on FlexNet Manager Forum. Sep 19, 2022 04:31 PM
- Posted Re: Does removing a target from automatic upgrade mean those devices will never upgrade? on FlexNet Manager Forum. Sep 06, 2022 08:35 AM
- Posted Does removing a target from automatic upgrade mean those devices will never upgrade? on FlexNet Manager Forum. Aug 24, 2022 01:37 PM
- Kudoed Re: How can Business Adapter change inventory device status when device has linked asset? for kclausen. Aug 12, 2022 08:27 AM
- Kudoed Re: Is there a way to view vm Hosts on a vCenter? for ChrisG. Aug 12, 2022 08:25 AM
- Kudoed Re: Is there a way to view vm Hosts on a vCenter? for kclausen. Aug 11, 2022 12:11 PM
- Kudoed Re: Is there a way to view vm Hosts on a vCenter? for kclausen. Aug 11, 2022 12:11 PM
- Posted Re: Is there a way to view vm Hosts on a vCenter? on FlexNet Manager Forum. Aug 11, 2022 08:25 AM
- Posted Re: Is there a way to view vm Hosts on a vCenter? on FlexNet Manager Forum. Aug 10, 2022 02:25 PM
- Posted Re: Is there a way to view vm Hosts on a vCenter? on FlexNet Manager Forum. Aug 10, 2022 02:02 PM
- Posted Is there a way to view vm Hosts on a vCenter? on FlexNet Manager Forum. Aug 10, 2022 11:15 AM
- Posted Re: Auto-cleanup of Obsolete FlexNet Inventory on Flexera One Blog. Aug 09, 2022 11:14 AM
- Posted Re: Auto-cleanup of Obsolete FlexNet Inventory on Flexera One Blog. Aug 08, 2022 03:30 PM
- Got a Kudo for How can Business Adapter change inventory device status when device has linked asset?. Jul 14, 2022 02:05 AM
- Got a Kudo for Re: Lease information not being populated in main asset form.. Jul 01, 2022 10:16 AM