About TeriStevenson

TeriStevenson · ‎Feb 12, 2021

Thanks Charles. I'm going to work with the SCCM team and see if they can create a collection for machines which have been replaced and/or decommissioned. Machines remain on the network for 90 days until they're removed. If I can get them to create a collection of these machines then I could use that as an exclude condition.

TeriStevenson · ‎Feb 09, 2021

2019 R1 and I've been seeing alerts generated in My Apps for machines in FNMS where the status is set to ignored and the last inventory date is in the past and wondering if this is as designed or perhaps I need to use some type of exclude view. The recent example is from yesterday. A user received a device replacement in November 2020 and his old device had a last inventory date of 11/5/2020 in FNMS and the status is ignored. The device exists in SCCM but has no heartbeat or scans. We have reclamation set up for products for 90 days non-use and send the user a notification. An alert was generated for the old device which is no longer on the network and set to ignored in FNMS. Does the reclamation code only check last used date for software only and no other criteria when generating the alert? If so, are there any suggestions for removing those alerts? This is causing confusion with the user base and the SAM team is constantly fielding questions for old devices.

TeriStevenson · ‎Jan 22, 2021

I have tried other ARL's and the query always returns 0 available even though the license entitlements show the correct information. We are still on 2017 R3 so I'm wondering if that is a bug with the version we are currently on.

TeriStevenson · ‎Jan 21, 2021

actual query is DECLARE @FlexeraID nvarchar(256) DECLARE @SoftwareTitleID int SET @FlexeraID = 'arl://MGS-APP-00000349885' SELECT @SoftwareTitleID = flexid.SoftwareTitleID FROM dbo.SoftwareRecognitionFlexeraID() AS flexid WHERE flexid.FlexeraID = @FlexeraID SELECT ISNULL(SUM(available.AvailableReservations),0) [Available Licences] FROM ( SELECT SoftwareLicenseID, AvailableReservations FROM dbo.SoftwareLicenseGetAvailableGlobalTable(@SoftwareTitleID) ) AS available

TeriStevenson · ‎Jan 21, 2021

Hi, We're having trouble with FNMP database showing correct license counts - this also affects App Portal. App Portal will always show 0 license available when FNMS shows there are 30. We ran the following query at the db for each ARKL tied to the Tableau Desktop Professional license and each query returns 0 available. When we view the license entitlements in FNMS - it shows 30 available based on purchases. Any ideas why the db queries don't retirn 30? DECLARE @FlexeraID nvarchar(256) DECLARE @SoftwareTitleID int SET @FlexeraID = 'aarl://MGS-APP-00000246863' SELECT @SoftwareTitleID = flexid.SoftwareTitleID FROM dbo.SoftwareRecognitionFlexeraID() AS flexid WHERE flexid.FlexeraID = @FlexeraID SELECT ISNULL(SUM(available.AvailableReservations),0) [Available Licences] FROM ( SELECT SoftwareLicenseID, AvailableReservations FROM dbo.SoftwareLicenseGetAvailableGlobalTable(@SoftwareTitleID) ) AS available

TeriStevenson · ‎Jan 19, 2021

Charles, I finally got back to this one after the holidays. After looking at the extensions and working with David we were able to determine the extensions are now in the store and we need to set the GPO policies with: Chrome: omfdapccbikpkiheohohbohhglmijeeb;https://clients2.google.com/service/update2/crx Edge: aejhddcfmefciddeneccplpjlnkfmapo;https://edge.microsoft.com/extensionwebstorebase/v1/crx

TeriStevenson · ‎Jan 15, 2021

I tried restarting the ESD service and that didn't fix it. I've involved the network folks here and they said it there is a user password brute force attempt showing. Can you tell me how the connection to IMAP works from the ESD service and what triggers the calls or what call is being made? There is nothing in the network logs showing an anomaly.

TeriStevenson · ‎Jan 12, 2021

We consistently see App Portal not able to login to the IMAP server. We reset the password, change the password in the configuration settings and it seems to work for awhile then stops again with LOGIN failed message. The same password is used for the service account on the ESD service and the application pools so I'm at a loss of why the email settings continue to have trouble. Yesterday I changed the service account password again and it has not resolved the issue in email. The MailParser_Error.log shows the following: Unexpected error while connecting to imap server : LOGIN failed. at MailKit.Net.Imap.ImapClient.<AuthenticateAsync>d__83.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at MailKit.Net.Imap.ImapClient.Authenticate(Encoding encoding, ICredentials credentials, CancellationToken cancellationToken) at MailKit.MailService.Authenticate(Encoding encoding, String userName, String password, CancellationToken cancellationToken) at AppPortal.Infrastructure.Services.MailParserService.ConnectToIMAPServer(MailParserConfiguration configuration, String& errormessage)

TeriStevenson · ‎Dec 11, 2020

Thanks Charles, The folks who do the GP policies asked me today where the code base is stored for the extensions so they can update the policies. Is it stored locally in esd/downloads/Chrome/Extensions or are is it in the Google and Microsoft stores?

TeriStevenson · ‎Dec 07, 2020

Microsoft Edge 85.0.564.51 was just implemented in our environment. I have some users reporting that Edge is opening IE in compatibility mode for them. I think this is due to the web.config having the following: <httpProtocol> <customHeaders> <add name="X-XSS-Protection" value="1; mode=block" /> <add name="X-Frame-Options" value="SAMEORIGIN" /> <add name="X-UA-Compatible" value="IE=9" /> <add name="X-Content-Type-Options" value="nosniff" /> Do I need to remove value=IE-9 or add Value="Edge" to this file? Looking for guidance on this. We're using DNS right now as the previous version web extensions weren't working in the environment and we have just packaged up version 3.0 of the extensions. I'm also wondering if version 3.0 web extensions will work with 2019 R1 until we upgrade to 2020 R1 in January

TeriStevenson · ‎Nov 24, 2020

I just checked both licenses and neither have upgrade/downgrade rights. What I did notice is the 2020 application only shows the 2020 license. The 2016 application has both the 2016 and 2020 license and we aren't able to remove the 2020 license. Any other suggestions? I'm at a loss on this one.

TeriStevenson · ‎Nov 24, 2020

We have 2 1099 Express applications - version 2016 and 2020. Each has it's own license however what we noticed is the 2020 application is also attached to the 2016 license. When we try to remove the application from the license and save, it gets added back. Has anyone had this happen with apps and licenses and if so, what causes this? We need to remove the application from the license but unable to do so.

TeriStevenson · ‎Nov 23, 2020

Will these web extensions work with 2019 R1 or only on 2020 R1?

TeriStevenson · ‎Oct 15, 2020

I finally got the file from the user and took a look at the file the user was trying to upload. It was a word doc and the user who had filled it out copy/pasted an email address so it had the html tags < and > Once I removed those it was able to be uploaded 🙂

TeriStevenson · ‎Oct 13, 2020

Seeing this in the logs Unhandled Exception http://servername/esd/DownloadFile.aspx?GUID= Conversion failed when converting from a character string to uniqueidentifier. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at DownloadFile.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Online Status	Offline
Date Last Visited	‎Feb 16, 2021 09:18 PM

Re: Reclamation Machine Status and Last Inventory Date

Reclamation Machine Status and Last Inventory Date

Re: License query in SQL does not match available license count in FNMS

Re: License query in SQL does not match available license count in FNMS

License query in SQL does not match available license count in FNMS

Re: Edge was just implemented in our environment Web.config file for Edge - App Portal 2019 R1

Re: Incoming Email Services Configuration

Incoming Email Services Configuration

Re: Edge was just implemented in our environment Web.config file for Edge - App Portal 2019 R1

Edge was just implemented in our environment Web.config file for Edge - App Portal 2019 R1

Re: Unable to remove application from license

Unable to remove application from license

Re: App Portal / App Broker 2020 R1 Web Extension Update

Re: Upload Files

Re: Upload Files

Re: Reclamation Machine Status and Last Inventory Date

Reclamation Machine Status and Last Inventory Date

Re: License query in SQL does not match available license count in FNMS

Re: License query in SQL does not match available license count in FNMS

License query in SQL does not match available license count in FNMS

Re: Edge was just implemented in our environment Web.config file for Edge - App Portal 2019 R1

Re: Incoming Email Services Configuration

Incoming Email Services Configuration

Re: Edge was just implemented in our environment Web.config file for Edge - App Portal 2019 R1

Edge was just implemented in our environment Web.config file for Edge - App Portal 2019 R1