CrowdStrikeCore table. Interim CMDB table

I decided to add this forum to keep track of solutions for DB related problems.
I have worked with some brilliant people in my life and the solutions to issues that are usually beyond something you can get at Jack in Box Jackson. They deserve historical marker. This is the historical marked on my map.
Pouzivej data base
Post Reply
hudatolah
Site Admin
Posts: 155
Joined: Thu Apr 04, 2013 8:10 pm
Are You a Headhunter?: Affirmative
Surfer?: Yes

CrowdStrikeCore table. Interim CMDB table

Post by hudatolah » Sun Sep 29, 2024 10:37 am

Code: Select all

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
DROP TABLE [dbo].[CrowdStrikeCore]

CREATE TABLE [dbo].[CrowdStrikeCore](
	[hostname] [varchar](128) NOT NULL,
	[machine_domain] [varchar](128) NULL,
	[external_ip] [varchar](128) NULL,
	[hrb_status_active] [bit] NULL,
	[bios_manufacturer] [varchar](64) NULL,
	[bios_version] [varchar](64) NULL,
	[product_type_desc] [varchar](128) NULL,
	[serial_number] [varchar](64) NOT NULL,
	[system_manufacturer] [varchar](64) NULL,
	[system_product_name] [varchar](64) NULL,
	[modified_timestamp] [datetime] NULL,
	[first_seen_create_date] [datetime] NULL,
	[last_seen] [datetime] NULL,
	[agent_local_time] [datetime] NULL,
	[mac_address] [varchar](64) NULL,
	[local_ip] [varchar](64) NULL,
	[device_id] [varchar](64) NULL,
	[cid] [varchar](64) NULL,
	[agent_version] [varchar](64) NULL,
	[ou] [varchar](256) NULL,
	[os_version] [varchar](64) NULL,
	[os_build] [varchar](64) NULL,
	[platform_name] [varchar](64) NULL,
	[reduced_functionality_mode] [varchar](64) NULL,
	[device_policies] [varchar](256) NULL,
	[groups] [varchar](256) NULL,
	[site_name] [varchar](128) NULL,
	[classid] [varchar](64) NULL,
	[last_update] [datetime] NULL,
	[last_update_by] [varchar](64) NULL,
	[instanceid] [varchar](37) NULL

) ON [PRIMARY]
GO
The Blackholesurfer. My surfboard has teeth.

hudatolah
Site Admin
Posts: 155
Joined: Thu Apr 04, 2013 8:10 pm
Are You a Headhunter?: Affirmative
Surfer?: Yes

Re: CrowdStrikeCore table. Interim CMDB table

Post by hudatolah » Sun Sep 29, 2024 10:38 am

Code: Select all

select * from dbo.CrowdStrikeCore

 insert into dbo.CrowdStrikeCore values 
 ('hostname','hrblock.com','255.255.255.255','1','Atari Inc.','2.0','Game Console','SN00000001','Atari','system_product_name',
getdate() ,getdate(),getdate() ,getdate() ,
 'mac_address','local_ip' ,'device_id','cid','agent_version','ou','os_version','os_build','platform_name','reduced_functionality_mode','device_policies','groups'
,'site_name','classid',getdate(),'last_update_by',newid()) 
 
SELECT TOP (1000) [hostname]
      ,[machine_domain]
      ,[external_ip]
      ,[hrb_status_active]
      ,[bios_manufacturer]
      ,[bios_version]
      ,[product_type_desc]
      ,[serial_number]
      ,[system_manufacturer]
      ,[system_product_name]
      ,[modified_timestamp]
      ,[first_seen_create_date]
      ,[last_seen]
      ,[agent_local_time]
      ,[mac_address]
      ,[local_ip]
      ,[device_id]
      ,[cid]
      ,[agent_version]
      ,[ou]
      ,[os_version]
      ,[os_build]
      ,[platform_name]
      ,[reduced_functionality_mode]
      ,[device_policies]
      ,[groups]
      ,[site_name]
      ,[classid]
      ,[last_update]
      ,[last_update_by]
  FROM [dbo].[CrowdStrikeCore]
The Blackholesurfer. My surfboard has teeth.