About dsalter

dsalter · ‎Oct 08, 2021

Is it possible to share the scripts is a .sql file? I am getting the following errors when attempting to run Clean Up Inventoried Computers and had similar errors on the Compliance History cleanup scripts. Msg 156, Level 15, State 1, Line 22 Incorrect syntax near the keyword 'on'. Msg 137, Level 15, State 1, Line 30 Must declare the scalar variable "@IncludedIDs". Msg 137, Level 15, State 2, Line 31 Must declare the scalar variable "@IncludedIDs". Msg 137, Level 15, State 2, Line 35 Must declare the scalar variable "@IncludedIDs". Msg 137, Level 15, State 2, Line 40 Must declare the scalar variable "@IncludedIDs". Msg 137, Level 15, State 2, Line 41 Must declare the scalar variable "@IncludedIDs". Msg 137, Level 15, State 2, Line 44 Must declare the scalar variable "@IncludedIDs".

dsalter · ‎Sep 23, 2021

My ComplianceHistory_MT is 800GB and is a series problem from a storage and cost perspective. I am happy to see this article as I opened a ticket with Flexera some time ago and was told there is no method to clean it up. You may want to mention you will want your database to be in Simple backup mode prior to starting this cleanup as you will likely overload your transaction logs if you are logging.

dsalter · ‎Jun 15, 2021

The service now inventory adapter was released to on-prem and cloud customers in the 2020R2 release. https://community.flexera.com/t5/FlexNet-Manager-Blog/ServiceNow-Inventory-Connector-in-FlexNet-Manager-Suite-2020-R2/ba-p/168980 This release required no additional licensing to my knowledge, unless you see an increase in active devices counts which would require FNMS licensing. The inventory adapter requires you install and configure the Flexera Integration on a ServiceNow mid-server. This is available on the ServiceNow app store. Assuming you just want ServiceNow device inventory imported into FNMS (One-way), from there you will just need to setup the powershell inventory adapter on your Flexera Beacon to have the service now data come into FNMS inventory. Hopefully I understood your question fully. 😉

dsalter · ‎Apr 22, 2021

Often when I find agents failing to report after installation, I find that firewall blocking was the cause of the issue and I needed to open ports between the two subnets to assure good communications. You can check that using a combination of pings, telnet and ssh to your Beacon server on the port it is listening, typically 80 or 8080

dsalter · ‎Mar 30, 2021

It looks to me the test connection logic is inconsistent with the actual automation so I wouldn't imagine it is having a problem. Likely because the Get-IAMUser call is made to validate credentials.

dsalter · ‎Mar 25, 2021

I do see that Get-IAMUser and other IAM user policy functions are being used outside the test connection function. So I assume the connector is not collecting all the information possible. Do you see any errors in the logs?

dsalter · ‎Mar 24, 2021

This indicates the account that is being used for the AWS EC2 connection is missing GetUser from the IAM Policy. Documentation status the following roles are required: DescribeInstances DescribeHosts DescribeReservedInstances GetUser. If you have access to the AWS console try reviewing the policy in the IAM console https://docs.flexera.com/FlexNetManagerSuite2020R2/EN/Features/index.html#FeatureList/2018R2/RN_feat_AWSEC2.html

dsalter · ‎Mar 04, 2021

I wanted to touch base to see if there was any further progress with this issue? I too am seeing this problem sporadically across the enterprise with the 2020 R1 agent.

dsalter · ‎Feb 12, 2021

I guess I had some other logic issue with my adapter. When I backed out me changes and used the word Active without any parenthesis all was good. Thanks for helping.

dsalter · ‎Feb 11, 2021

We have a customer user data enrichment routine using a business adapter. Since we have begun to reuse AD user names I need to update our matching rules to look for only Users and Managers in the Active status. For the example below I am trying to adjust the Matching rule to include both 'Account Name = [ADAccountName]' and 'User Status = 'Active'. After making the change the record is rejected. I have tried mulitple variants as well, Active, "Active", 1. Could someone shed some light I what I can do to match only on active records?

dsalter · ‎Jan 12, 2021

I have attached an example of a business adapter which populates an inventory target from an excel spreadsheet containing a list of server names. The business adapter process 1. Clears the existing target list 2. Populates a staging table from the spreadsheet contents 3. Repopulates the target from the spreadsheet list of servers I am using this automation to support the need to remotely inventory XenDesktop parents which is a pain to keep maintained for an organization our size. You can reuse this for different purposes just remember I hardcoded the insert to the BeaconTargetDiscoveredDeviceMapping_MT table columns TenantID and Include to value of 1. This may need to be updated for your purposes. Any other changes needed for the business adapter xml are in <> brackets. Please don't critique my work too much I didn't spend much time on this. It does work nice though.

dsalter · ‎Jan 11, 2021

I am using the following database query as part of a compliance process to prove ADDM computers are in FNMS --Verify ADDM Computers are in FNMS inventory, expect results for AIX LPARs and VIO(AIX) machines as these are assigned a --different Serial number in FNMS than is discovered by ADDM to avoid duplication of serial numbers SELECT * FROM [AddmStaging].[dbo].[Host_ci] LEFT JOIN [FNMS].[dbo].[ComplianceComputer_MT] as Comp ON [AddmStaging].[dbo].[Host_ci].Serial = Comp.SerialNo WHERE [AddmStaging].[dbo].[Host_ci].Serial IS NOT NULL AND Comp.SerialNo is NULL

dsalter · ‎Oct 01, 2020

Thanks for the quick response. Tracking the enhancement request.

dsalter · ‎Sep 28, 2020

Has anyone had any experience collecting XenApp and XenDesktop inventory from the Citrix Hosted Citrix Virtual Apps and Desktops? I am not sure if the XenApp Server agent and XenDesktop Discovery and Inventory Rules will run on the vendor hosted offerings. Interested to see what others have used for this platform as a service offering.

dsalter · ‎Jul 24, 2020

Thanks for the solution. Hopefully there is a defect to resolve this.

Online Status	Offline
Date Last Visited	‎Nov 24, 2021 07:59 PM

Re: FNMS Inventory Computer and History deletion scripts

Re: FNMS Inventory Computer and History deletion scripts

Re: FNMS to Servicenow Integration

Re: FNMS Agent Not Reporting After Installation

Re: AWS Powershell adapter - Test Connection Error

Re: AWS Powershell adapter - Test Connection Error

Re: AWS Powershell adapter - Test Connection Error

Re: FlexNet Manager Platform cannot access the directories

Re: Business Adapter Matching For User Status

Business Adapter Matching For User Status

Re: Populate Inventory Target through automation

Re: Inventory devices inventoried from ADDM don't show up in FNMS UI

Re: Citrix Inventory from Citrix Cloud Services

Citrix Inventory from Citrix Cloud Services

Re: Upgrade from 2019 R2 to 2020 R1 failing with error

Re: FNMS Inventory Computer and History deletion scripts

Re: FNMS Inventory Computer and History deletion scripts

Re: FNMS to Servicenow Integration

Re: FNMS Agent Not Reporting After Installation

Re: AWS Powershell adapter - Test Connection Error

Re: AWS Powershell adapter - Test Connection Error

Re: AWS Powershell adapter - Test Connection Error

Re: FlexNet Manager Platform cannot access the directories

Re: Business Adapter Matching For User Status

Business Adapter Matching For User Status