Posts

Jmeter-CheatSheet

-
Image
  Functions and Variables  Jmeter Time - ${__time(dd/MM/yyyy hh:mm:ss)} UUID - ${__UUID()}  Email (Random) - ${__V(${__UUID()}${__Random(1,90000000,)}@gmail.com)} Random - ${__Random(0,10)}  Random Date - ${__RandomDate(,,2050-07-08,,)}  Random String - ${__RandomString(10,abcdefg)}  Time shift - ${__timeShift(dd/MM/yyyy,21/01/2018,P2D,,)}  Convert epoch - ${__dateTimeConvert(1526574881000,,dd/MM/yyyy HH:mm,)}  Upper Case - ${__changeCase(Avaro omnia desunt\, inopi pauca\, sapienti nihil,UPPER,)} Lower Case - ${__changeCase(LABOR OMNIA VINCIT IMPROBUS,LOWER,)}  URL encode - ${__urlencode(Word "school" is "école" in french)}  URL decode - ${__urldecode(Word+%22school%22+is+%22%C3%A9cole%22+in+french)}  Thread Num - ${__threadNum}  Thread Group - ${__threadGroupName}  Escape HTML - ${__escapeHtml("bread" & "butter")}  Unescape HTML - ${__unescapeHtml(<Français>)}  CRLF - ${__unescape(\r\n)} Split - ${__sp...
Post a Comment
Read more

JMETER-DSL | Java Coded Framework for Performance testing using jmeter

-
  Releases · abstracta/jmeter-java-dsl (github.com) User guide | jmeter-java-dsl (abstracta.github.io)
Post a Comment
Read more

Connect Azure KeyVault in Azure China or other Azure Version

-
 https://stackoverflow.com/questions/71846554/connect-to-keyvault-in-azure-china https://learn.microsoft.com/en-us/dotnet/api/azure.identity.azureauthorityhosts?view=azure-dotnet Azure China The host of the Azure Active Directory authority for tenants in the Azure China Cloud. Azure Germany The host of the Azure Active Directory authority for tenants in the Azure German Cloud. Azure Government The host of the Azure Active Directory authority for tenants in the Azure US Government Cloud. Azure Public Cloud The host of the Azure Active Directory authority for tenants in the Azure Public Cloud. var clientSecretCredentialOptions = new ClientSecretCredentialOptions() { AuthorityHost = AzureAuthorityHosts.AzureChina }; ClientSecretCredential clientCredential = new (options.KeyVaultTenantId, options.KeyVaultClientId, options.KeyVaultClientSecret, clientSecretCredentialOptions); KeyVaultCertificateWithPolicy rootCertificate = new CertificateClient(vaultUri, _clientCredential).GetC...
Post a Comment
Read more

JMETER | Recording gzip issue

-
Image
 Simply in the recording controller, choose type as "JAVA", setting is isn very down section of recording controller
Post a Comment
Read more

Imp Things to know for Perf Dynamics Engineer

-
  What is RSAT? How to donwnload/Install and use of the same what is DMF What is oData How to get the tables names of any form How to get DB Creds How to Connect to DB and Write SQL Commands How to Create Users How to Add Roles to Users What is perosn/Employee how it is linked t a store/warehouse etc. how to use advanced find filter in CRM
Post a Comment
Read more

oData Filters

-
  for dates simply pass date without any quotes $filter=Birthday eq 2017-12-31 for any special type of data use its entity property: like 'Microsoft.Dynamics.DataEntities.NoYes' Find the Entity type and pass it From <https://learn.microsoft.com/en-us/odata/webapi/date-timeofday-with-entity-framework>  https:/XYZ/data/SystemUsers?$top=1&$filter=IsRetail eq Microsoft.Dynamics.DataEntities.NoYes'No'
Post a Comment
Read more

SQL | SQL SERVER | Group by Minutes

-
In order to group the data with 10 minutes bucket of date, use following SQL: Group by 10 Minutes SQL Server select count(*), DATEADD(MINUTE, DATEDIFF(MINUTE, '2000', SUBMITTEDDATETIME) / 10 * 10, '2000')  AS [date_truncated] from ThawTable where  cast(ThawingDate  as date) = cast('2022-03-21' as date) and THAWQTY <> 0  group by status,DATEDIFF(MINUTE, '2000', SUBMITTEDDATETIME) / 10 order by 1 desc;
Post a Comment
Read more