Find Jobs
Hire Freelancers

Move Event Viewer Logs to MS SQL Server every 5 Minutes

₹1500-12500 INR

Tamamlandı
İlan edilme: 3 ay önce

₹1500-12500 INR

Teslimde ödenir
I need an expert C# and Powershell programmer to create a utility that transfers Terminal Server Session Logs to a MS SQL database. Data to be moved to SQL Server : - EventRecordID - Date and Time - Guid - User - EventID - Computer - SessionID / Target SessionID - Address - Source Session ID Event Ids RemoteDesktopService - SessionServices - Operational : 21, 23, 24, 25, 39 Last EventRecordID to be stored in Registry or anywhere else so next time fetch data greater then last stored EventRecordID SQL Server 3 Tables need to be updated 1. Rawlogs (above mentioned dump of Logs) 2. LoginandLogout (GUID, Date, User Name, Login Time, Logout Time, Logon Time, Computer, Address, Reason, Status (Approval Pending/Approved)) for each event 3. Total (Date, User Name, First Login Time, Last Logout Time, Working Hrs, Manual Working Hrs, Total Working Hrs, Reasons For Manual Working Hrs for each Date) Ideal Skills: - Proficiency in C# and Power Shell Programming - Solid experience with MS SQL Database - Understands Terminal Server Session and Security Logs Tasks: - Develop a C# and Power Shall utility to capture Terminal Server Logs - Successfully transfer/store this data in MS SQL Database every 5 Minutes Webpage: - Admin can watch All user data (Raw Logs) - Admin/Each user can watch there First Login Time, Last Logout Time and Logon duration for each date - User/Admin can also watch each event of that date (login time , Logout time and logon duration) - User/Admin can filter both reports based on date range - Admin can Filter data for all users/selected users - Admin can filter data where logon duration for the day is less the Hrs (drop down 1,2,3,4,5-15) - Admin can filter data Date Wise / Total for a date or a date range where logon Duration will be clubbed for each user - User can manual add data with Reason in 2nd table from front end - Admin can approve the manual entry from Front End and after approval it will be updated in 3rd table in Manual updated Hrs , Remarks and Total working hrs will be updated (all manual entries of that user for that date will be concatenated in Manual Hrs Total and Reason (comma separated) Please Quote separately 1. Auto update of all 3 tables (MS SQL Server) 2. Reports (3 Formats and one Front Page (Need to detect current logged in user on server Administrator or Equivalent / normal user) to be designed in C# which can be hosted on windows server.
Proje No: 37804252

Proje hakkında

7 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 3 ay önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
With your valuable project in upgradation, I believe my wide-ranging skillset in C# and Power Shell programming make me a strong candidate for this job. Having 6 years of experience, I'm well-versed in software design, analysis and implementation, especially in web and client-server applications. In addition to my proficient grasp on MSSQL databases, I have an adept understanding of Terminal Server Sessions and Security Logs - which would prove handy in enabling me to channel Event Viewer logs to your desired target in MS SQL Server with accuracy and efficiency. To maintain the integrity of the data being moved, I propose implementing an automated system that performs this task every 5 minutes; saving the EventRecordID onto a Registry that would help save progress between transfers. Further, the Data would be split into three separate tables while adhering to the requirements stated.
₹8.400 INR 4 gün içinde
5,0 (2 değerlendirme)
2,3
2,3
7 freelancer bu proje için ortalama ₹11.071 INR teklif veriyor
Kullanıcı Avatarı
Hello, I have good Powershell scripting experience along with SQL and handling event viewer logs I can help you to complete the project as per your requirement Kindly ping me and award the project Thanks
₹12.500 INR 7 gün içinde
5,0 (114 değerlendirme)
6,6
6,6
Kullanıcı Avatarı
I have similar experience for event viewer log to database table, i can do it , we can discuss over chat to start ...
₹8.000 INR 3 gün içinde
4,9 (43 değerlendirme)
6,0
6,0
Kullanıcı Avatarı
Hi Greetings! We are a team of software developers. We have developers working on almost all the technologies. We will assign you a project manager who will assist you during the entire process of project completion. We will provide you with fast, timely, and on-time delivery at reasonable and minimum cost. We are a registered company located in Indore, India. We are available right now for the project discussion and can start the project on an immediate basis. We understand your project requirement We have 12 ++ years of experience in design and development. We can handle projects from small styling to full development from scratch. We will provide a good result in a short time and satisfy you fully. We have experienced developers in .NET C# Programming Microsoft SQL Server Powershell WHY-Us: » Ready to Start on an Immediate basis &provide proper Testing. » Keep your Data & Website Secure: Daily Progress Updates. » You will get 30 days FREE BUG-SUPPORT even after Project-Completion Please come in touch and let's discuss more detail about your task via chat. Project milestones will be decided during the chat. Thanks and Regards Tech India
₹12.500 INR 5 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hello, I’m a technical lead for a large firm specialising in automation such as this and the creation of SIEM applications. I’m confident I have the ability to write and deliver what you require.
₹12.000 INR 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   INDIA bayrağı
Delhi, India
0,0
0
Ödeme yöntemi onaylandı
Eki 3, 2022 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.