Odbc powershell일자리
...Requirements: - Export - import budget is on low side - Establish a seamless connection between Shopify and Mariadb for the following tables: Products, Collections, Orders, and Customers. - Sync the data across both systems in real-time - Ensure the integration supports Products, Orders, and Customer Information. -NEW ODBC driver with DB functions like INSERT, UPDATE, DELETE, budget is on higher side Prior experience with Shopify and Mariadb integration is highly desirable. Proficiency in ODBC or a similar protocol is a bonus. Your ability to ensure the system is robust, secure, and scalable will be pivotal. Interested freelancers should be able to demonstrate: - Past experience with similar integrations - Strong communication skills and a proactive approach - The abil...
We have four network drives (T:, U:, V:, W:). Each contain the same file structure of: DCF[School Name][6-digit code]Original Day - Booking AND Retake Day - Booking Within each Original/Retake folder there are subfolders: BP Backup Create Database Folder Digital Fix Images IWS Folder PowerShell script (run using Task Scheduler), needs to delete all above identified subfolders where the "BP Backup" folder is 48+ hours old. Screenshots to follow.
I am in need of a PowerShell script that can extract active SharePoint & Teams sites within the last 30, 60, 90, 120, and 180 days. The script needs to be reusable, allowing for easy modifications by just changing the number of days. The desired output should be in CSV format. The essential information needed from the SharePoint and Teams sites are: - Site Name - URL - Site Owner - Site Members - Site Creation Date - Last Accessed Date (in DD/MM/YYYY format) It's crucial that the script handles sites that have been deleted or are no longer accessible by ignoring these and continuing with the processing. Ideal Skills: - Advanced knowledge of PowerShell scripting - Experience working with SharePoint and Microsoft Teams - Proficiency in data extraction and manipulat...
I need a PowerShell script that identifies users not connected to Azure for the past two months. The script should generate a report in Excel format. This report should specifically include the last login dates of these users. Ideal Skills and Experience: - Proficient in PowerShell - Experience with Azure
I'm looking for a skilled developer to design and implement an Endpoint Detection and Response (EDR) system specifically tailored for Windows 11. The primary goal of this software is to provide top-notch malware detection capabilities, network protection with NIDPS , Custom Rules based protection. Key Features: - **Malware Detection**: I need a s...suggest actions to take against potential exploits. - **Network/Endpoint Monitoring**: Comprehensive monitoring of both network and endpoint activities is crucial for a robust EDR system. - **Automated Threat Handling**: The system should be able to automatically quarantine detected threats without requiring manual intervention. The EDR system should be built using a combination of Python and PowerShell, ensuring high performance a...
I need a professional Azure DevOps expert to help fix my build process. The issue is that the code is not being written into the SQL server from the pipeline, even though it works perfectly fine from PowerShell ISE. Key Requirements: - Deep understanding of Azure DevOps - Strong troubleshooting skills - Experience with SQL server and PowerShell - Ability to fix the Azure DevOps pipeline build process
...knowledge and experience in system automation, deployment, and implementation. • Deep understanding of the Microsoft Windows 10 and 11 operating systems, including the Windows registry, win32 and x64 application structure. • Candidates must possess experience in using Azure AVD, Azure AD, Azure Network, Azure security and Storage and ample experience in configuring and automating the tasks through PowerShell...
Hi Do u have experienced both powershell and Databse Administrator please. I need support vai zoom for my consultant Before we processed please noted 1. This support only count hour on zoom meeting.. no offline work count 2. 11$/hourly payment every saturday . 3. I already have other indian guys who are working with me since many years now 4. Today at 8:30 pm we will see your capability after then we will continous.. so its important today
I'm in need of an expert who can automate the installation and monitoring of a cluster environment. This environment includes various technologies such as MSSQL, Informatica, and PowerBI. The cluster environment will be running on Windows operating system. Active Directory integration/Keycloak is also required. Key Requirements: - Automate the installation ...authorization Ideal Applicant: - Proven experience in automating the setup and monitoring of cluster environments - Proficiency in working with MSSQL, Informatica, and PowerBI - Familiarity with Active Directory and/or Keycloak - Strong communication skills and attention to detail In your application, please include past work that showcases your experience in similar projects. Strong knowledge of PowerShell,docker, shel...
...of a professional proficient in Power BI who can assist me in a number of tasks. Key tasks include: - Setting up an ODBC connection in Power BI for extracting Tally financial data. - Implementing a mechanism that restricts access to this data, ensuring its integrity and security. - Developing comparison reports based on the Tally financial data. - Creating a dashboard for me within Power BI using this same data. Specifically, I'm looking for your help in making the data fetching process more efficient, as currently there are speed issues with the operation. Ideal candidates should: - Have strong experience in Power BI Desktop - Possess advanced knowledge of Tally and ODBC connections - Be capable of developing comparison reports and dashboards within Power BI - Be ...
...certain tasks to demonstrate their competency to be considered for employment. ===== REQUIREMENTS ===== - Microsoft Azure Configuration, Deployment & Administration (Virtual Machines, Networks, Storage) - Microsoft Office 365 Configuration, Deployment & Administration & Migration expert - Microsoft Intune Administration & Support - Azure Virtual Desktop, Administration and Deployment - Extensive PowerShell scripting - Windows Server (2012 R2, 2016, 2019, 2022) - Ability to learn and manage applications in an enterprise environment - IT Security solutions and applications ===== PLUSES===== - Programming and development experience (C, C#, Python, etc.) - Knowledge of internet firewall and Ethernet switching in a business environment - Proficiency in: GP's, ...
We are a non profit organization seeking an Excel & SQL Reporting Specialist for an upcoming project. Your expertise will be instrumental in automating our monthly reports by navigating NetSuite tables and executing SQL queries via ODBC. Ideal skills and experience: - Advance experience in Excel and SQL - Strong Financial reporting background - Experience with NetSuite tables and ODBC connectors - Strong analytical and problem-solving skills Your attention to detail and ability to interpret complex data will be crucial. A solid reporting background can ensure accuracy and readability of the financial reports, aiding our decision-making process.
I am in need of a freelancer who can help automate the process of populating SharePoint lists using an Excel file. The ideal candidate for this project should have a solid background in PowerShell scripting and prior experience with SharePoint. The Excel file I will provide for this task is structured consistently, with the same format for each row of data. Your role will be to develop a script that can read the Excel file and efficiently transfer its data into the corresponding SharePoint lists. Key Requirements: - Strong proficiency in PowerShell scripting - Prior experience with SharePoint - Ability to work with consistent data structure In your application, please share examples of your past work that demonstrate your expertise in these areas.
I'm looking for a PowerShell expert with experience in SharePoint Online to create a script that will automatically synchronize SharePoint files to the user’s Windows Explorer, provided they have permission to access these files. The key requirements for this project include: - The script should cater to SharePoint Online. - It needs to automatically set up synchronization for all users. - No specific file types are to be included or excluded from the synchronization. - The script should be user-friendly and robust for various user profiles. I expect the freelancer to have a solid understanding of PowerShell and experience working with SharePoint Online. They should be able to create an efficient, automated solution that ensures a seamless synchronization proces...
...a dynamic Javascript website's status using Microsoft Edge and send an email notification when the connection is down. The script should be built using Powershell, C# and Selenium. Key Requirements: - Use Microsoft Edge: The script should use Microsoft Edge to access the website and check its status. - Frequent Checks: The script should check the website's status every 5 minutes. This ensures timely detection of any connection issues. - Email Notification: I prefer to receive an email notification when the connection is down. The script should be able to send an email alert in this case. Skills and Experience: - Proficiency in Powershell, C# and Selenium: The script needs to be implemented using these technologies. - Web Automation Expertise: Experience in web...
I'm seeking a professional who can set up Apache Guacamole on both Windows and Ubuntu servers to access RDP and SSH over Browser. Requirement: 1. Installation: Configure and install Apache Guacamole on both my Windows and Ubuntu servers. a. Need Shell script to install on Ubuntu Server. b. Need PowerShell script to install on Windows Server. 2. Configuration: Ensure proper configuration and smooth running of the service.
I am seeking a proficient DevOps professional, equipped with experience in Jenkins, Ansible, Docker, Python, Terraform, Shell Script, OpenShift, GitHub, Azure, AWS, Linux, and PowerShell. The primary goal of this project is the effective automation of the deployment process. Ideal candidates must possess the following skills: - Mastery of development and deployment tools including Jenkins, Ansible, Docker, Python, and Terraform. - Comfort in using Shell Script, OpenShift, GitHub, Azure, AWS, and PowerShell. - Familiarity with Linux and Windows platforms and environments. The objective is to enhance efficiency and streamline processes within a Linux and Windows environment. This opportunity is best suited for an individual who has a knack for system optimization. Being able...
I'm in need of a PowerShell expert to help me create a custom XML file. This file should have taskbar items for commonly used applications: Outlook, Word, Chrome, Excel, and Teams. Additionally, this XML should also sync SharePoint files that the user has permission to access to their profile. However, there's a unique twist - the sync should occur only on a "files on demand" basis. This is to avoid downloading large folders. Key requirements: - Development of a custom XML file or powershell script - Integration of the taskbar items for specified applications - Automatically sync SharePoint files to user's profile - Sync to occur only when user accesses Windows Explorer Ideal Skills & Experience: - Proficiency in PowerShell scripting - Pr...
I'm in need of an expert who can automate the installation and monitoring of a cluster environment. This environment includes various technologies such as MSSQL, Informatica, and PowerBI. The cluster environment will be running on Windows operating system. Active Directory integration/Keycloak is also required. Key Requirements: - Automate the installation ...authorization Ideal Applicant: - Proven experience in automating the setup and monitoring of cluster environments - Proficiency in working with MSSQL, Informatica, and PowerBI - Familiarity with Active Directory and/or Keycloak - Strong communication skills and attention to detail In your application, please include past work that showcases your experience in similar projects. Strong knowledge of PowerShell,docker, shel...
Hi Sir, I am a certified Microsoft certified tech having more than 13 years of experience working as a Senior System Admin. I am specialize in comprehensive email migration and administrative tasks across various platforms. Here's an overview of my expertise: I have done many GoDaddy to M365 Defederation with the PowerShell scripts, It will take me very less time to defederate the tenant. I promise all of your emails, passwords, calendar, contacts, groups, SharePoint, DL, M365 groups will not effect. None of users will effect from this. Also I have great track record of migrating emails, calendar, contacts, one drive, Gdrive to destination tenant. Google to office365 Including (Emails, calendar , Contacts, Drive) M365 to Google workspace or Gsuite (Including Emails, calenda...
Project: Create script to eliminate incorrect punctuation and duplicate lines We have many individual txt files that have abbreviated words with the period (full stop) in the wrong place as well as duplicated lines of text. The script will: 1. Open each txt file. 2. Find specific incorrect words and replace them with a version without the period (full stop). 3. Find duplicated lines, eliminate the duplicates but leave one line in the file. 4. Save the txt file and move onto the next one in the folder.
Technical Skills Required: Windows Server Administration: Familiarity with Windows Server operating systems. Understanding of server roles and features installation. Networking: Knowledge of IP addressing and subnetting. Understan...SPF, DKIM, DMARC). User Authentication: Configuring user permissions and authentication methods for secure access. Documentation and Configuration Management Documentation: Ability to document the setup process and configurations for future reference. Maintaining records of changes made to the server settings. Additional Skills Scripting/Automation (optional): Knowledge of PowerShell for automating configurations and tasks. Email Client Configuration: Familiarity with configuring email clients for sending and receivi...
I need a PowerShell expert to create a script that will export specific data from our vSphere infrastructure. This will include: Cluster DRS Configuration status(Specfic configuration), Cluster Usage Report, (morethen80%) ESXi State(MM/NR/Disconnected) & ESXi alarm report(RED) from n number of vCenters and clusters The ideal freelancer should have extensive experience with both vSphere and PowerShell scripting, understanding the complexities of extracting detailed virtual machine and host data. Efficiency and accuracy are paramount.
PLEASE READ FIRST looking for an expert in powershell (dont tell me you need x days for a script, than you are NOT an expert and your bid will be deleted) i need round about 10 scripts like 1. HR should modify users 2. server install and configure script 3. software modify script (based on groups) 4. file server modify script 5. password reset for users 6. and some more this tasks include a script for configuring the permission on ADS i tell you which function i need, we discuss the time and price and we define a milestone. ONLY EXPERTS NEED TO APPLY
I'm looking to partner with a keen and experienced software marketer for advertising my automation software. Its prime feature is Windows Server Automation, by utilizing PowerShell and PS-RemoteSession allowing businesses to automate their repeating operations. Your experience should include: - Proven record in software marketing, ideally IT software. - Understanding of business needs and how automation can solve operational/financial challenges. - Strategic insight to effectively promote task automation tools. Your responsibilities: - Identifying appropriate marketing channels. - Executing effective marketing strategies. - Increasing awareness and driving software adoption within the business community. - Increasing website views - Increasing client engagement - Increasin...
I'm seeking a professional who can set up Apache Guacamole on both Windows and Ubuntu servers. Requirement: 1. Installation: Configure and install Apache Guacamole on both my Windows and Ubuntu servers. a. Need Shell script to install on Ubuntu Server. b. Need PowerShell script to install on Windows Server. 2. Configuration: Ensure proper configuration and smooth running of the service.
...bulk migrations is essential. Backup process pre-migration will be necessary. External tools can be used, such as BitTitan. Ideal Candidate: - Experience: Proven experience in migrating data between cloud services, preferably from GoDaddy to Microsoft 365. - Microsoft 365 Expertise: A deep understanding of the Microsoft 365 suite, particularly the email, contact, and calendar functions. - PowerShell expertise as it pertains to preparing SSI, Federation, and Exchange commands. - Efficient and Reliable: Punctuality and a meticulous approach to data migration are crucial to this project's success. Please note that there are no customizations or specific configurations in our current GoDaddy 365 tenant. The email spam filter is currently Zix, so MX records would need to ref...
... Familiarity with cloud security best practices, particularly in AWS, Azure, or GCP environments. · In-depth knowledge of cybersecurity threats, vulnerabilities, and attack vectors. · Ability to perform advanced threat analysis and correlation. · Strong incident response and forensic investigation skills. · Proficiency in scripting and automation (e.g., Python, PowerShell) is an advantage. · Strong interpersonal skills and ability to work effectively in a team-oriented environment. · Ability to manage multiple tasks and priorities in a dynamic and fast-paced environment. Qualifications: · Minimum of 8+ years of experience in security operations, incident response, or related ro...
...orchestration tools (e.g., Terraform, CloudFormation). Security: Solid understanding of security best practices and regulatory compliance requirements. Problem-Solving: Excellent problem-solving and troubleshooting skills. Communication: Ability to communicate effectively with technical and non-technical stakeholders. Scripting: Proficiency in scripting and automation (e.g., JavaScript, Python, PowerShell, Linux shell scripting) is an advantage. Qualifications: Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent experience). Professional certifications such as CIS-ITOM, AWS Certified Solutions Architect, AWS Certified SysOps Administrator, or equivalent are highly desirable. Minimum 8+ years of experience in Servicenow ITOM, in...
I have an of MS Access with a series forms used for data entry and management that connects (with ODBC) to an PostgreSQL database. I'm looking for an experienced web developer to transfer (redesign) these interfaces into a responsive website format that's also mobile and tablet friendly to connect directly to the PostgreSQL database, and scrap the ms access front-end . The design needs to be fancy and modern looking. Key Points: -User authentication - Designing a web interface that replicates the functionality of the MS Access forms for data entry and management. - Ensuring that the website is responsive and works well on mobile and tablet devices. - Data integrity and security should be paramount. - Aesthetic and user-friendly interface design. Ideal Candidates: - Exte...
...El candidato ideal debe tener experiencia comprobada en: Office 365 y Exchange: Configuración y administración. PowerShell: Automatización y scripting para tareas administrativas. Tenant de Azure: Configuración y administración. Migración de Bases de Datos de Correos: Experiencia en mover y gestionar bases de datos de correos electrónicos. Requisitos: Idiomas: Español nativo o fluido. Experiencia: Demostrable en los campos mencionados. Habilidades Técnicas: Profundas en PowerShell, Azure y Exchange. Disponibilidad: Para trabajos puntuales según se necesite. Responsabilidades: Configuración y administración de Exchange en Office 365. Automatización de tareas utilizando PowerShe...
Your task is to create a script which will meet the following criteria: • Create a menu system o The menu system must be read from a text file () o The path to the file must be relative to the location of the script (do not reference absolute paths!) o The menu will allow users to select an option that they wish to pick from • Tasks (Options form the menu) o The user is presented with a list of options that relate to: 1. File and folder actions/activities 2. Process/Service activities/actions o Each Task/Option must be fully functional o The script must have at least two functions, one of the functions must accept a pipeline input. • Guidelines: o The script must be creative and complex. The scope must be significantly focused on the cmdlets and concepts we’ve learne...
We have many Excel files containing one column of text, each line of text on a different row. We need this to be converted into a txt file with the same file name. And extra tabs and hard returns to be removed.
We have many individual txt files, each in their own individual folder. We need a script that renames the txt files and moves them into a different folder.
This is part of a problem that I am trying to solve for some time now: Need to run SQL queries against a MariaDB database on a remote machine from within FileMaker server (on a Mac). For that I need ssh and/or sudo for the FileMaker server user. As a sidenote: ODBC works with FileMaker server, but it is far too slow and not really useable. Furthermore FileMaker’s SQL is somewhat limited. I'd like to directly query the remote data base. What I need works perfectly fine in bash: Mac Terminal => ssh into remote machine => Query MariaDB data base. It also works fine using a FileMaker client: FileMaker client => bBox Plugin => shell command ssh => Query MariaDB data base. However, it doesn't work on FileMaker server! The reason is that FileMa...
I am in need of a Powershell script that can quickly determine if a passed domain group like "Domain Admins" has effective permissions to the allow logon locally user right in a Windows 10 environment. The function should return a bool and look something like this "Domain Admins" | CheckLoginLocally This way I can pipe any group to it like: "Domain Users" | CheckLoginLocally Key requirements and details include: - I'm looking for a Powershell script that will only return the final result as True or False. - The script should solely focus on determining if the piped group has effective permissions to the allow logon locally user right. - The project needs to be completed as soon as possible. The ideal freelancer for this project should ...
As an expanding organization, we require an experienced PowerShell script developer to monitor the Meraki Cloud network. The script should be capable of assessing performance, although the specifics are still open for interpretation. Create a PowerShell script to monitor Meraki Cloud availability and performance. Here are the basic metrics which are need to be monitored: Cisco: Meraki Device up/down status Cisco: Meraki Organization License and expiry alerts in 30 days - Configure email to be sent to your email id(configurable email address) Cisco: Meraki Uplink Status(up/down) - The device interface(MX device) should be consistently down for 10 minutes before raising the incident Cisco: Meraki VPN Status (state change) Cisco: Meraki firewall interface loss/latency ( thresh...
...information on the subject, but I cannot figure it out. Specifically, I require: - The successful implementation of the the latest Ublock Origin via the registry. - If you are going to code anything, it has to be written in PowerShell and not Python. The urgency of this project requires an experienced freelancer with the following skills: - Proficiency in Windows registry modification. - Extensive experience in Firefox extension installation. - Ability to work under pressure and deliver within a tight timeframe. Please respond only if you meet the above criteria and are confident in your ability to complete this task ASAP
Tools: Terraform: For writing declarative configuration files to manage Azure resources. Azure Resource Manager (ARM) Templates: For JSON-based templates that define the infrastructure and configuration for your project. PowerShell & Azure CLI: For scripting and executing commands to manage Azure resources and Terraform configurations. Detailed Steps Project Planning and Requirements Gathering Identify the components of the web application infrastructure (e.g., Azure Web Apps, Azure SQL Database, Azure Functions, Virtual Networks, etc.). Define scalability, security, and compliance requirements. Environment Setup Install Terraform and Azure CLI on your local machine or CI/CD pipeline environment. Configure Azure CLI with your Azure account credentials. Terraform Configuration...
We need a freelancer who can programmatically modify Chrome / Edge default search without using an extension. We must include there our own redirection link which will redirect to our own search results, this should be done in powershell.
I'm looking for a talented PowerShell developer to create a script that will help me identify out-of-date software. Key Requirements: This task is to write a PowerShell script with a two functions. First function is to create a list of applications and their versions. You can do this by screen scraping the link below and finding all the applications storing their name, version, description and tags. Store all these details in a pscustomobject. If you wish to use another list you can as long as it has up to date software on it. The second function is to determine the list of installed software on the computer and find out if needs updating
As an expanding organization, we require an experienced PowerShell script developer to monitor the Meraki Cloud network. The script should be capable of assessing performance, although the specifics are still open for interpretation. Create a PowerShell script to monitor Meraki Cloud availability and performance. Here are the basic metrics which are need to be monitored: Cisco: Meraki Device up/down status Cisco: Meraki Organization License and expiry alerts in 30 days - Configure email to be sent to your email id(configurable email address) Cisco: Meraki Uplink Status(up/down) - The device interface(MX device) should be consistently down for 10 minutes before raising the incident Cisco: Meraki VPN Status (state change) Cisco: Meraki firewall interface loss/latency ( thresh...
Go to a set of web sites according steps enclosed in the guide to copy a subset of values and pass over captcha validation. Key Responsibilities: - Copying and scraping data from a list of websites - Saving the extracted data into csv files Technical requirement: - The expectation is to automate using powershell scrip or .net console app
...need a PowerShell script that can monitor and send email notifications for soon-to-expire client secrets and certificates within Azure. Key Requirements: - The script should be able to identify client secrets and certificates that are due to expire in 7, 15, and 30 days. - If an application or app registration does not have an owner assigned, the script should send the email notifications to a specific distribution list. Ideal Features: - Utilize HTML email templates for polished and professional notifications. - Include detailed logging, capturing individual email details and error logs, to ensure the script's operations are transparent and easily traceable. The script should be efficient, reliable, and easy to integrate into the Azure environment. Experience with Azure...
I require an advanced SQL Server Database Trainer, with a specialized focus on Database Administration and Performance Tuning. Migrating from Ms. Access to Sharepo...Ideal Candidate: - Strong communication and teaching skills. - Prior experience in training individuals with varied levels of SQL Server Database, PowerApps, and Sharepoint knowledge, PowerBi - MS SQL Server, SQL queries, table structures, automation, backups, recovery, validation, database configuration. - Web Services, MS PowerBI, Ibase for efficient database management. - Skilled in writing PowerShell scripts for task automation, data retrieval, and manipulation. - Ability to efficiently cover the specified training areas within a week. -Able to corroborate to move access database to Powerapps, Sharepoint/ Microsoft ...
I am looking for a proficient PowerShell scripter who can help me create a code. This script must be capable of detecting every time a specific USB device is plugged in. Once the USB is detected, an automatic email notification is to be sent to the administrator via Gmail. Detailed information about the USB device and the exact time of connection should be included in the said notification. Ideally, you should: * Have a firm understanding of PowerShell and its integration with Gmail services. * Be able to write scripts that can discern specific USB devices. * Have prior experience in generating and sending email notifications from scripts. * Understand how to incorporate USB device details in an email notifications. * Be attentive to details, especially when capturing and re...
I'm in need of an experienced freelancer to help me with importing and updating assets from to on a real-time basis. The script must give us an option to enter the client on id in atera and as well as ITflow. Write the script in Powershell. Must have variables for Keys, server/endpoints, and client IDs. The API for Atera is here under devices: The API info for ITflow is here: If the asset existing is ITFlow and it has a different information, the script should update the asset with the new information.
I am looking for an expert to create Sage ODBC reports to pull specific financial data from Excel files. The ideal candidate should have strong skills in Excel, Sage ODBC reporting, and financial analysis. Key Responsibilities: - Create Sage ODBC reports pulling financial data from Excel - Include Profit and Loss data and Balance Sheet details in reports Preferred Skills and Experience: - Proficient in Excel - Familiar with Sage ODBC reporting - Background in financial data analysis, specifically profit and loss, and balance sheet data.
I need a PowerShell script to secure access to the Desktop version of Outlook by prompting for a password regardless of how Outlook is accessed (e.g., from the Taskbar, Desktop, Start Menu, etc.). Requirements: 1. The script should prompt the user for a password when they attempt to open Outlook. 2. The password must be securely stored using PowerShell’s secure string methods or Windows Credential Manager. 3. The password must not be decipherable by editing the script. 4. The password can be changed later by the user if needed.
